Your question is Compare Department Spend to Budget. Start with the requirements and the three tables 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.
You are given departmental budget data and actual expense transactions. Write a PostgreSQL query that compares actual spend versus budget by department and returns each department’s budget, actual spend, variance, and variance percentage.
| Column | Type | Description |
|---|---|---|
| department_idPK | INT | Primary key for the department |
| department_name | VARCHAR(100) | Department name |
| Column | Type | Description |
|---|---|---|
| budget_idPK | INT | Primary key for the budget record |
| department_id | INT | References departments.department_id |
| budget_month | DATE | Month the budget applies to |
| budget_amount | DECIMAL(12,2) | Approved budget amount for the month |
| Column | Type | Description |
|---|---|---|
| expense_idPK | INT | Primary key for the expense transaction |
| department_id | INT | References departments.department_id |
| expense_date | DATE | Date the expense was incurred |
| amount | DECIMAL(12,2) | Expense amount |
| status | VARCHAR(20) | Expense status such as approved, pending, or rejected |