More restricting

There are multiple positions possible for eSymphony employees:

Title
General Manager
IT Manager
IT Staff
Sales Manager
Sales Support Agent

You are interested in setting up a mentoring program. In positions where there are multiple employees, more senior members will coach more recent hires of the team. To do this you decide to generate a list with the title and hire date of the most recent addition to the team, and this for each position.

Select the employee Title and the hire date of the most recent hire from the Employee table.
Group the results by title.

Take Hint (-15 XP)

Exercise

More restricting

Instructions 1/2