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

True Running Total With Salary Ties | Algorithm

Hard

HardwindowSQL

True Running Total With Salary Ties

Return each employee's name, salary, and a running total of salary ordered from lowest to highest. Two employees are tied on salary — each employee's running total must reflect their own individual position in that order (i.e. the running total must NOT jump to the same value for both tied employees).

Expected output

First 3 of 10 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.