The most recent hire in each department

SQLHard13 min

Your task

For each department that has employees, return the most recently hired person. Give department, name and hired_on, ordered by department name. If two people were hired the same day, return both.

Tables

department
idINTEGERnameTEXT
1Engineering
2Sales
3Design
4Research
employee
idINTEGERnameTEXTsalaryINTEGERdepartment_idINTEGERmanager_idINTEGERhired_onTEXT
1Ada1800001NULL2021-03-01
2Grace165000112022-06-15
3Linus140000112023-01-09
4Mel1200002NULL2020-11-20
5Kay120000242023-04-02
6IvanNULL242024-02-17
More rows not shown