[LeetCode][SQL50] #13. Managers with at Least 5 Direct Reports

💻 문제 주소 : Managers with at Least 5 Direct Reports - LeetCode

Students and Examinations - LeetCode

 

💻 문제

Write a solution to find managers with at least five direct reports. Return the result table in any order.

- 적어도 직접 보고를 최소 5번 받은 매니저를 출력하시오. 출력 순서는 상관 없습니다.

 

💻 코드 및 풀이 

select name -- 여기서 name은 column name
from Employee
where id in (select managerID from Employee group by managerID having count(managerID) >= 5)