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.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- 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
___ ___ ___