1978. 上级经理已离职的公司员工
题目链接:1978. 上级经理已离职的公司员工
代码如下:
# Write your MySQL query statement below
select employee_id
from Employees
where salary<30000
and manager_id is not null
and manager_id not in (select employee_id from Employees)
order by employee_id