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.
Deze oefening maakt deel uit van de cursus
Introduction to Oracle SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- 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
___ ___ ___