1978. Employees Whose Manager Left the Company.md

1978. Employees Whose Manager Left the Company

Question Link

Solution

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