LeetCode SQL 50

[IamShiwangi]

1978. Employees Whose Manager Left the Company

[iamAntimPal]

SELECT e1.employee_id
FROM
    Employees AS e1
    LEFT JOIN Employees AS 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 1;

for explanation click on me

[IamShiwangi]

Thank you sir