managers-who-left-the-company.sql (376B)
1 --Given a table with employees and their managers 2 --return all employees who have a manager that does not 3 --have an associated record. 4 5 SELECT Employees.employee_id 6 FROM Employees 7 LEFT JOIN Employees AS E 8 ON Employees.manager_id = E.employee_id 9 WHERE Employees.salary < 30000 10 AND (E.employee_id IS NULL AND Employees.manager_id IS NOT NULL) 11 ORDER BY Employees.employee_id ASC