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.
Cet exercice fait partie du cours
Introduction to Oracle SQL
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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
___ ___ ___