Employees_Whose_Manager_Left_the_Company.sql

SELECT DISTINCT E2.EMPLOYEE_ID FROM EMPLOYEES E1,EMPLOYEES E2 WHERE E2.SALARY<30000 AND
E2.MANAGER_ID NOT IN(SELECT EMPLOYEE_ID FROM EMPLOYEES) ORDER BY EMPLOYEE_ID;