Is this a correct answer ?
Thanks for reaching out.
The code is correct but the result output should be 2 rows. You can use the following code:
e.emp_no IN (SELECT
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.