# $570. 至少有5名直接下属的经理
# https://leetcode-cn.com/problems/managers-with-at-least-5-direct-reports/

# SQL架构
Create table If Not Exists Employee (id int, name varchar(255), department varchar(255), managerId int);
Truncate table Employee;
insert into Employee (id, name, department, managerId) values ('101', 'John', 'A', null);
insert into Employee (id, name, department, managerId) values ('102', 'Dan', 'A', '101');
insert into Employee (id, name, department, managerId) values ('103', 'James', 'A', '101');
insert into Employee (id, name, department, managerId) values ('104', 'Amy', 'A', '101');
insert into Employee (id, name, department, managerId) values ('105', 'Anne', 'A', '101');
insert into Employee (id, name, department, managerId) values ('106', 'Ron', 'B', '101');

# Write your MySQL query statement below
select
    name
from
    Employee as t1
    join (
        select
            managerId
        from
            Employee
        group by
            managerId
        having
            count(managerId) >= 5
    ) as t2 on t1.id = t2.managerId;

# clean-up
drop table Employee;