having1 [LeetCode] Classes More Than 5 Students (group by, having, count, distinct) SELECT class FROM courses GROUP BY class HAVING COUNT(DISTINCT student) > 4; class 로 group by 한후 class 당 unique한 (distinct) student를 count한 결과가 4보다 큰 class 만 select 2021. 4. 9. 이전 1 다음