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

답 쿼리입니다.

SELECT name
FROM (
    SELECT E1.managerId
        , E2.name
        , COUNT(*) count
    FROM Employee E1
        join Employee E2 ON E1.managerId = E2.id
    GROUP BY E1.managerId
) AS T
WHERE count >= 5