Question

用SQL 语言统计各门课程 的学生人数

Answer 1

select course ,count(*) from <表名> group by course;

Answer 2

SELECT MAX(各门课程),COUNT(学生ID) FROM TABLENAME GROUP BY 各门课程