Task
You are given a table of Ramp card transactions and asked to build a simple monthly spend summary similar to a lightweight Excel model. Write a SQL query that returns total approved spend by month for 2024, excluding declined transactions. Show the month in YYYY-MM format and order the results from highest total spend to lowest.
Schema
ramp_card_transactions
| 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 such as approved or declined |
Sample data
| 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 |
Expected output
| spend_month | total_approved_spend |
|---|
| 2024-03 | 770.00 |
| 2024-01 | 380.50 |
| 2024-02 | 251.00 |
