力扣---高频SQL题---37---1978. 上级经理已离职的公司员工

一、题目

二、代码

# Write your MySQL query statement below
select employee_id  from Employees 
where salary <30000 
and manager_id  not in
(
   select employee_id  from Employees 
)
order by employee_id  asc

三、运行结果