Find the ids of the employees who does not work in those departments where some employees works whose manager id within the range 100 and 200.
SELECT * FROM employees WHERE department_id NOT IN (SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200)
SELECT * FROM employees WHERE department_id NOT IN (SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200)
[{'EMPLOYEE_ID': 178, 'FIRST_NAME': 'Kimberely', 'LAST_NAME': 'Grant', 'EMAIL': 'KGRANT', 'PHONE_NUMBER': '011.44.1644.429263', 'HIRE_DATE': '1987-09-03', 'JOB_ID': 'SA_REP', 'SALARY': 7000, 'COMMISSION_PCT': 0.15, 'MANAGER_ID': 149, 'DEPARTMENT_ID': 0}, {'EMPLOYEE_ID': 201, 'FIRST_NAME': 'Michael', 'LAST_NAME': 'Hartstein', 'EMAIL': 'MHARTSTE', 'PHONE_NUMBER': '515.123.5555', 'HIRE_DATE': '1987-09-26', 'JOB_ID': 'MK_MAN', 'SALARY': 13000, 'COMMISSION_PCT': 0, 'MANAGER_ID': 100, 'DEPARTMENT_ID': 20}, {'EMPLOYEE_ID': 202, 'FIRST_NAME': 'Pat', 'LAST_NAME': 'Fay', 'EMAIL': 'PFAY', 'PHONE_NUMBER': '603.123.6666', 'HIRE_DATE': '1987-09-27', 'JOB_ID': 'MK_REP', 'SALARY': 6000, 'COMMISSION_PCT': 0, 'MANAGER_ID': 201, 'DEPARTMENT_ID': 20}, {'EMPLOYEE_ID': 203, 'FIRST_NAME': 'Susan', 'LAST_NAME': 'Mavris', 'EMAIL': 'SMAVRIS', 'PHONE_NUMBER': '515.123.7777', 'HIRE_DATE': '1987-09-28', 'JOB_ID': 'HR_REP', 'SALARY': 6500, 'COMMISSION_PCT': 0, 'MANAGER_ID': 101, 'DEPARTMENT_ID': 40}, {'EMPLOYEE_ID': 204, 'FIRST_NAME': 'Hermann', 'LAST_NAME': 'Baer', 'EMAIL': 'HBAER', 'PHONE_NUMBER': '515.123.8888', 'HIRE_DATE': '1987-09-29', 'JOB_ID': 'PR_REP', 'SALARY': 10000, 'COMMISSION_PCT': 0, 'MANAGER_ID': 101, 'DEPARTMENT_ID': 70}, {'EMPLOYEE_ID': 205, 'FIRST_NAME': 'Shelley', 'LAST_NAME': 'Higgins', 'EMAIL': 'SHIGGINS', 'PHONE_NUMBER': '515.123.8080', 'HIRE_DATE': '1987-09-30', 'JOB_ID': 'AC_MGR', 'SALARY': 12000, 'COMMISSION_PCT': 0, 'MANAGER_ID': 101, 'DEPARTMENT_ID': 110}, {'EMPLOYEE_ID': 206, 'FIRST_NAME': 'William', 'LAST_NAME': 'Gietz', 'EMAIL': 'WGIETZ', 'PHONE_NUMBER': '515.123.8181', 'HIRE_DATE': '1987-10-01', 'JOB_ID': 'AC_ACCOUNT', 'SALARY': 8300, 'COMMISSION_PCT': 0, 'MANAGER_ID': 205, 'DEPARTMENT_ID': 110}]