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

문제

https://leetcode.com/problems/managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50

코드

WITH m_c AS(
    SELECT
        managerId,
        COUNT(managerId) AS cnt
    FROM
        Employee
    GROUP BY
        managerId
)
SELECT
    em.name
FROM
    Employee em
    LEFT JOIN m_c
        ON em.id=m_c.managerId
WHERE 1=1
    AND m_c.cnt>=5

풀이

요런 테이블에서 managerId를 그룹화 하여 카운팅한 숫자가 5 이상이어야 됨.
그래서 셀프 조인하고 윗처럼 풀었다.
훠훠훠