문제
풀이
- there is a table courses with coluns: student and class
- please list out all classes which have more than or equal to 5 students.
- for example, the table.
쿼리
-- leetcode, Classes More Than 5 Students, mysql
SELECT class
FROM courses
GROUP BY class
HAVING COUNT(DISTINCT student) >= 5결과
