570. Managers with at Least 5 Direct Reports : leetcode

SELECT  name
FROM    Employee
WHERE id = 
    (
    SELECT managerId
    FROM Employee 
    WHERE managerId IS NOT NULL
    GROUP BY managerId
    HAVING count(managerId) >= 5
    );

→ Subquery returns more than 1 row

SELECT  name
FROM    Employee
WHERE id =
    any(
    SELECT managerId
    FROM Employee 
    WHERE managerId IS NOT NULL
    GROUP BY managerId
    HAVING count(managerId) >= 5
    );

any 대신 in을 사용해도 되고, JOIN을 사용해도 된다.