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.
Latihan ini adalah bagian dari kursus
Introduction to Oracle SQL
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- 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
___ ___ ___