Write a PostgreSQL query on ramp_card_transactions that returns total approved spend by month for calendar year 2024. Show the month as YYYY-MM and sort the output by total spend descending.
| Column | Type | Description |
|---|---|---|
| transaction_id | INT | Unique transaction ID |
| employee_name | VARCHAR(100) | Employee who made the purchase |
| merchant_name | VARCHAR(100) | Merchant on the card transaction |
| transaction_date | DATE | Date of the transaction |
| amount | DECIMAL(10,2) | Transaction amount in USD |
| status | VARCHAR(20) | Transaction status |
| transaction_id | employee_name | merchant_name | transaction_date | amount | status |
|---|---|---|---|---|---|
| 1 | Maya Chen | Delta | 2024-03-05 | 420.00 | approved |
| 2 | Leo Park | Amazon Business | 2024-01-12 | 180.50 | approved |
| 3 | Maya Chen | Uber | 2024-03-18 | 65.25 | declined |
| 4 | Nina Shah | Notion | 2024-02-02 | 96.00 | approved |