570. 至少有5名直接下属的经理
题目链接:570. 至少有5名直接下属的经理
代码如下:
# Write your MySQL query statement below
select name
from Employee
where id in(
select distinct ManagerId
from Employee
group by ManagerId
having count(ManagerId)>=5
)
题目链接:570. 至少有5名直接下属的经理
代码如下:
# Write your MySQL query statement below
select name
from Employee
where id in(
select distinct ManagerId
from Employee
group by ManagerId
having count(ManagerId)>=5
)