leet code sql 596
링크 - https://leetcode.com/problems/classes-more-than-5-students/
문제
- class 별로 최소 5명이 수강중인 강의
문제 접근
- group by 와 having을 이용하여 구성
1
2
3
4
5
select
class
from Courses
group by class
having count(*) >= 5
Jr Data Engineer
링크 - https://leetcode.com/problems/classes-more-than-5-students/
1
2
3
4
5
select
class
from Courses
group by class
having count(*) >= 5