LC 596超过5名学生的课Classes With at Least 5 Students 简单
Courses 表记录学生选课;列出选课学生不少于 5 人的课程。
思路 GROUP BY class + HAVING COUNT(DISTINCT student) >= 5。
SELECT class
FROM Courses
GROUP BY class
HAVING COUNT(DISTINCT student) >= 5;
数据表:Courses · 关键字:列出选课学生不少于 5 人的课程