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

문제

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.

 

 

쿼리

SELECT
    NAME
FROM EMPLOYEE
WHERE ID IN (
    SELECT
        MANAGERID
    FROM EMPLOYEE
    GROUP BY
        MANAGERID
    HAVING
        COUNT(MANAGERID) >= 5
);

 

제출하고 보니 생각보다 실행 시간이 길게 나왔다. 생각해보니 그냥 조인만 써서도 풀 수 있을 것 같아서 쿼리를 다시 작성했다

 

SELECT
    E.NAME
FROM EMPLOYEE E
JOIN EMPLOYEE M
    ON E.ID = M.MANAGERID
GROUP BY
    M.MANAGERID
HAVING
    COUNT(M.MANAGERID) >= 5;

 

 

 

 

 

문제 출처

https://leetcode.com/problems/managers-with-at-least-5-direct-reports/