Question

SQL语句中找出最多人选修的三门课程的课程号，以及统计选修人数，并按人数降序排列？

Answer 1

你这个是在课程成绩表中查询吧。
select top 3 courseID as courseid ,count(courseID) as num
from 课程选修成绩表
group by courseID
order by num desc
已经测试成功

Answer 2

select top 3 课程号,count(*) from 选课表 group by 课程号 order by count(*) desc