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
'SQL' 카테고리의 다른 글
[LeetCode] Swap Salary (update, ENUM, SET, CASE, IF) (0) | 2021.04.09 |
---|---|
[LeetCode] Not Boring Movies (0) | 2021.04.09 |
[LeetCode] Rising Temperature (interval, self join) (0) | 2021.04.09 |
[LeetCode] Delete Duplicate Emails (delete, self join, and) (0) | 2021.04.09 |
[LeetCode] Customes Who Never Order (is null, join) (0) | 2021.04.09 |
댓글