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
name
salary
running_total
Hugo Im
80000
80000
Gia Hall
90000
170000
Eve Fox
95000
265000
First 3 of 10 rows your query should return. Your column aliases don't need to match.