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
-- 39、求每门课程的学生人数
最新推荐文章于 2023-03-29 16:30:27 发布
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