1270 向公司ceo汇报工作的所有人（中等 ） 三表联立

Create table If Not Exists Employees (employee_id int, employee_name varchar(30), manager_id int)
Truncate table Employees
insert into Employees (employee_id, employee_name, manager_id) values ('1', 'Boss', '1')
insert into Employees (employee_id, employee_name, manager_id) values ('3', 'Alice', '3')
insert into Employees (employee_id, employee_name, manager_id) values ('2', 'Bob', '1')
insert into Employees (employee_id, employee_name, manager_id) values ('4', 'Daniel', '2')
insert into Employees (employee_id, employee_name, manager_id) values ('7', 'Luis', '4')
insert into Employees (employee_id, employee_name, manager_id) values ('8', 'John', '3')
insert into Employees (employee_id, employee_name, manager_id) values ('9', 'Angela', '8')
insert into Employees (employee_id, employee_name, manager_id) values ('77', 'Robert', '1')

select a.employee_id 
from 
(select   employee_id, employee_name,manager_id 
from  Employees  
where  employee_id!=1 ) a
left join  Employees  b on a.manager_id = b.employee_id
left join  Employees  c on b.manager_id = c.employee_id
left join  Employees  d on c.manager_id = d.employee_id 
where d.manager_id =1