先找出有5个下属的经理的Id
SELECT name FROM Employee WHERE id IN ( SELECT managerId FROM Employee GROUP BY managerId HAVING COUNT(*)>=5);
Last updated 3 years ago