JavaScript is required for SkillDojo to work properly. Please enable JavaScript and refresh the page.

Employee Hire Order in Department | Algorithm

Easy

EasywindowSQL

Employee Hire Order in Department

The HR team wants to see how recently each employee was hired within their own department to identify recent hires. For each employee, show their name, department, hire date, and their hire order within that department (where 1 is the earliest hire).

Return

name : employee's name department_id : employee's department hired_on : employee's hire date hire_order : the order in which the employee was hired within their department (1 = earliest) Show only employees who belong to a department. Order rows by department_id, then by hire_order .

Expected output

name	department_id	hired_on	hire_order
Ana Reyes	1	2018-03-01	1
Ben Cho	1	2019-06-15	2
Cara Diaz	1	2020-01-20	3

First 3 of 9 rows your query should return. Your column aliases don't need to match.

Tables · HR — Departments & Employees

departments

idINTEGERpknameTEXT

employees

idINTEGERpknameTEXTdepartment_idINTEGER→departments.idnullmanager_idINTEGER→employees.idnullsalaryINTEGERhired_onTEXT

id	name	department_id	manager_id	salary	hired_on
1	Ana Reyes	1	NULL	150000	2018-03-01
2	Ben Cho	1	1	120000	2019-06-15
3	Cara Diaz	1	1	120000	2020-01-20
4	Dan Ellis	2	NULL	140000	2017-11-05
5	Eve Fox	2	4	95000	2021-02-10

0 of 3 hints revealed

Submit an attempt first.