Your question is Find Departments with High Expenses. 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.
Appzen Expense Auditor needs a simple report showing departments with unusually high submitted expense totals. Treat any department with total expenses greater than $10,000 as unusually high.
Write a PostgreSQL query that summarizes the expenses table and returns only departments above this threshold.
department and calculate each department's total expense amount.HAVING to retain only departments whose total exceeds 10000, then sort the results from highest to lowest total.| Column | Type | Description |
|---|---|---|
| expense_idPK | INT | Unique expense record identifier |
| department | VARCHAR(50) | Department that incurred the expense |
| expense_amount | NUMERIC(12,2) | Expense amount in US dollars |
| expense_date | DATE | Date the expense was submitted |
| approval_status | VARCHAR(20) | Current approval state |