Problem Description –
Write an SQL query to report the IDs of the employees whose salary is strictly less than
$30000 and whose manager left the company. When a manager leaves the company, their information is deleted from the
Employees table, but the reports still have their
manager_id set to the manager that left.
Return the result table ordered by
The query result format is in the following example.
Problem Link – Manager Left
Difficulty Level – Easy
SELECT employee_id FROM Employees WHERE manager_id NOT IN (SELECT employee_id FROM Employees) AND salary < 30000 ORDER BY employee_id;