[LeetCode] 570. Managers with at Least 5 Direct Reports

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT m.name
FROM Employee AS e
    INNER JOIN Employee AS m ON e.managerId = m.id
GROUP BY m.id
HAVING COUNT(DISTINCT e.id) >= 5