596. 超过5名学生的课

https://leetcode-cn.com/problems/classes-more-than-5-students/

MySQL

# Write your MySQL query statement below
SELECT class
FROM courses
GROUP BY class
HAVING COUNT(DISTINCT student) >= 5;