力扣SQL50 上级经理已离职的公司员工 一题双解

Problem: 1978. 上级经理已离职的公司员工

Code

-- 方法 1 
-- select e1.employee_id 
-- from employees e1
-- left join employees e2
-- on e1.manager_id = e2.employee_id
-- where e1.salary < 30000 
-- and e1.manager_id is not null 
-- and e2.employee_id is null
-- order by e1.employee_id

select employee_id
from employees
where salary < 30000
and manager_id not in (select employee_id from employees)
order by employee_id