[LeetCode] 596. Classes More Than 5 Students

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH student_cnt AS (
    SELECT class
         , COUNT(DISTINCT student) AS cnt
    FROM Courses
    GROUP BY class
)

SELECT class
FROM student_cnt
WHERE cnt >= 5