Last answered:

21 Nov 2022

Posted on:

20 Nov 2022

0

Is this a correct answer ?

image.png

1 answers ( 0 marked as helpful)
Instructor
Posted on:

21 Nov 2022

0

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

Submit an answer