SELECT * FROM employees WHERE department_id NOT IN (SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200)
What are the ids for employees who do not work in departments with managers that have ids between 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 value and value )
What are the ids for employees who do not work in departments with managers that have ids between 100 and 200 ?