leetcode

0 SELECT E.employee_id

1 FROM Employees E

2 LEFT JOIN Employees M

3 ON E.manager_id = M.employee_id

4 WHERE E.salary < 30000 AND

5 M.employee_id IS NULL AND

6 E.manager_id IS NOT NULL

7 ORDER BY E.employee_id