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