LeetCode - 570. Managers with at Least 5 Direct Reports (MySQL)

Medium, SQL - Nested Query by own table

RunTime : 316 ms

문제

Write a solution to find managers with at least five direct reports.

Return the result table in any order.

The result format is in the following example.

풀이

• managerId 필드에 5번 이상 등장하는 id값을 찾는 문제
• 분명 풀어봤었는데 못 풀었다.

SELECT name FROM Employee
WHERE id IN (
    SELECT managerId
    FROM Employee
    GROUP BY 1
    HAVING COUNT(*) >= 5
)