代码:
# Write your MySQL query statement below
select t1.employee_id
from(
select employee_id,manager_id
from Employees
where salary<30000
)t1
left join
Employees t2
on t1.manager_id=t2.employee_id
where t2.employee_id is null and t1.manager_id is not null
order by t1.employee_id