What are the employee ids who work in those departments?
SELECT employee_id FROM employees WHERE department_id IN  ( SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200 ) 
employee ids who work in those departments refers to selecting employee_id from employees based on a condition related to departments; the condition for the departments is having a manager_id between 100 and 200;