思路:找出至少有五个直接下属的经理,可以理解为在Employee表中找出managerId行id相同的至少有五个,这就是我们要找出的经理的id
select managerId
from employee
group by managerId
having count(managerId)>=5
找到经理的id后我们直接在employee表中查询经理的名字就行了(用子查询)
select name
from employee
where id in(select managerId
from employee
group by managerId
having count(managerId)>=5)