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

Top Three Salaries Per Department With Manager Info

Hard

HardwindowSQL

Top Three Salaries Per Department With Manager Info

The HR team is preparing a feature to highlight top earners in each department. They need a list of up to three employees with the highest salaries in every department, including anyone tied at those salary levels. For each, provide the employee's name, salary, their manager's name (or NULL if they have none), and the department name.

Return

department_name : the name of the department employee_name : the employee's name salary : the employee's salary manager_name : the manager's name or NULL if none Only include employees assigned to a department. Results should be ordered by department name, then by salary (highest first), then by employee name.

Expected output

department_name	employee_name	salary	manager_name
Engineering	Ana Reyes	150000	NULL
Engineering	Ben Cho	120000	Ana Reyes
Engineering	Cara Diaz	120000	Ana Reyes

First 3 of 8 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 4 hints revealed

Submit an attempt first.