Your question is Monthly Ramp Card Spend Summary. 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.
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 |