– 求每门课程的学生人数
SELECT
c.c_id,
c.c_name,
COUNT(1)
FROM course c
INNER JOIN score sc ON sc.c_id=c.c_id
GROUP BY c.c_id
– 求每门课程的学生人数
SELECT
c.c_id,
c.c_name,
COUNT(1)
FROM course c
INNER JOIN score sc ON sc.c_id=c.c_id
GROUP BY c.c_id