leetcode 570 至少有5名直接下屬的經理-526互联

至少有5名直接下屬的經理

子查詢

select `name` from Employee where id in (
    select managerId from Employee 
    group by managerId
    having count(managerId) >= 5
)

自連接

select e2.name from Employee e1 ,Employee e2
where e1.managerId = e2.id
group by e2.id
having count(e1.id) >= 5