Department Expenses
Start Timer
0:00:00
As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).
Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.
Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.
Example:
Input:
departments table
| Column | Type |
|---|---|
| id | INTEGER |
| name | VARCHAR |
expenses table
| Column | Type |
|---|---|
| id | INTEGER |
| department_id | INTEGER |
| amount | FLOAT |
| date | DATE |
Output:
| Column | Type |
|---|---|
| department_name | VARCHAR |
| total_expense | FLOAT |
| average_expense | FLOAT |
.
.
.
.
.
.
.
.
.
Comments