SCHEMA:
CREATE TABLE departments (department_id VARCHAR, manager_id INTEGER); CREATE TABLE employees (department_id VARCHAR, manager_id INTEGER)
USER:
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.

QUERY:
SELECT * FROM employees WHERE NOT department_id IN (SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200)