README.md

570. 至少有 5 名直接下属的经理

English Version

题目描述

None

解法

SQL

SELECT Name
FROM Employee
WHERE Id IN
    (SELECT ManagerId
    FROM Employee
    GROUP BY  ManagerId
    HAVING count(*) >= 5)