SELECT
c.c_id,
c.c_name,
COUNT(1)
FROM course c
LEFT JOIN score sc ON sc.c_id=c.c_id
GROUP BY sc.c_id
-- 26、查询每门课程被选修的学生数
最新推荐文章于 2023-10-21 12:30:00 发布
SELECT
c.c_id,
c.c_name,
COUNT(1)
FROM course c
LEFT JOIN score sc ON sc.c_id=c.c_id
GROUP BY sc.c_id