Your question is Accumulated Salary Sum in SQL. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |