Write a SQL query to calculate the accumulated salary sum.
Asked in the Onsite Round 1 stage. SQL question starting simple and getting progressively harder.
Return employee_id, employee_name, salary, and accumulated_salary_sum, ordered by salary ascending, then employee_id ascending.
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Employee identifier |
| employee_name | VARCHAR(100) | Employee name |
| salary | INT | Monthly salary |