Can someone tell me if this answer is correct? SELECT e.hire_date, e.first_name FROM employees e WHERE e.emp_no IN (SELECT dm.emp_no FROM dept_manager dm) HAVING e.hire_date BETWEEN "1990-01-01" AND "1995-01-01" The solution: | | | | | |

It is not the right answer since you didn't retrieve what the question wants : "Information about all department managers who .." your outer select statement should be from dept_manager table, and your inner select statement from employees which contains 'hire_date' that is the key to filter all employees.

Hi Maged! Thanks for reaching out. Yes, this is also a valid solution. You used other tables but the result set is correct. You can check with the following query: SELECT * FROM employees WHERE emp_no IN (110420 , 111877); You will obtain the same employees: Oscar and Xiaobin. Hope this helps. Best, Tsvetelin