order by a.courseid; 题目37:.统计每门课程的学生选修人数(超过 5 人的课程才统计) 分析:这题目的思路已经写过很多次了 group by courseid count(student) SELECT courseid, COUNT(studentid) FROM student_score GROUP BY courseid HAVING COUNT(studentid)>5...