Payroll by department, biggest first
SQLMedium10 min
Your task
Return the total recorded salary per department as department and payroll, largest payroll first. Departments with no recorded salaries do not appear.
Tables
department| idINTEGER | nameTEXT |
|---|
| 1 | Engineering |
| 2 | Sales |
| 3 | Design |
| 4 | Research |
employee| idINTEGER | nameTEXT | salaryINTEGER | department_idINTEGER | manager_idINTEGER | hired_onTEXT |
|---|
| 1 | Ada | 180000 | 1 | NULL | 2021-03-01 |
| 2 | Grace | 165000 | 1 | 1 | 2022-06-15 |
| 3 | Linus | 140000 | 1 | 1 | 2023-01-09 |
| 4 | Mel | 120000 | 2 | NULL | 2020-11-20 |
| 5 | Kay | 120000 | 2 | 4 | 2023-04-02 |
| 6 | Ivan | NULL | 2 | 4 | 2024-02-17 |
Model answerRun