1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL

Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • Select the employee Title and the hire date of the most recent hire from the Employee table.
  • Group the results by title.