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.
This exercise is part of the course
Introduction to Oracle SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select the title and the date of the most recent hire
SELECT ___, ___(___) AS "Most recent hire date"
-- The data comes from the Employee table
___ ___
-- Group by title
___ ___ ___