Hello! In the exercise, we had to display the number of department managers who were hired between the 1st of January 1990 and the 1st of January 1995. According to the solution, the displayed date after execution is the from & to dates. On the contrary shouldn't it be the hire date? Also, I tried the question without using a subquery and got a slightly different result which looked more appropriate according to the question. Waiting for your response. I am just wondering. I may be wrong. SELECT e.emp_no,e.first_name,e.last_name,e.hire_date,d.dept_noFROM employees e JOIN dept_manager d ON e.emp_no=d.emp_noWHERE e.hire_date BETWEEN '1990-01-01' AND '1995-01-01'ORDER bY e.emp_no;

Hi Archisman! Thanks for reaching out. This is a great observation indeed! In fact, what we achieve with the query we suggest is an output as obtained from the dept_managers table for all managers that have been hired in the company for the first time between Jan 1 1990 and Jan 1 1995. We don't display any information from the employees table. The query you suggest responds to this part of the question. However, it doesn't involve the use of a subquery, which is what the purpose of the exercise is about. Thank you very much for paying attention to this subtlety! I will revise it with my colleagues and will update the task text/suggested solution accordingly. Hope this helps.Kind regards,Martin

Follow this topic

Archisman Das

Last answered:

18 Nov 2020

Posted on:

16 Nov 2020

Resolved: Solution Modification

1 answers ( 1 marked as helpful)

Martin Ganchev

Instructor

Posted on:

18 Nov 2020

Helpful answer

Resolved: Solution Modification

Submit an answer