can we write the query like this:
FROM employees e
WHERE (e.hire_date BETWEEN '1990-01-01' AND '1995-01-01' )
AND e.emp_no IN( SELECT dm.dept_no FROM dept_manager dm);
Thanks for reaching out.
The query is correct in terms of syntax but as Yumma said it returns 0 rows. Please, stick to the provided solution as this method does not work.
Hope this helps.