Is this a correct answer ?
1 answers ( 0 marked as helpful)
Hi Yahia!
Thanks for reaching out.
The code is correct but the result output should be 2 rows. You can use the following code:
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";
You have to use the column hire_date as it is different from from_date.
Hope this helps.
Best,
Tsvetelin