본문 바로가기
SQL

[LeetCode] Classes More Than 5 Students (group by, having, count, distinct)

by YGSEO 2021. 4. 9.
728x90
SELECT class FROM courses GROUP BY class HAVING COUNT(DISTINCT student) > 4;

class 로 group by 한후

class 당 unique한 (distinct) student를 count한 결과가 4보다 큰

class 만 select

728x90

댓글