What are the department ids with managers who have ids between 100 and 200?
select department_id from departments where manager_id between 100 and 200
What is all the information about employees who do not work in those departments?
select * from employees where department_id not in (select department_id from departments where manager_id between 100 and 200)