Skip to main content
All Problems
medium0% acceptance

Monthly Transaction Count and Volume

The operations team wants a monthly summary of transaction activity. For each month (YYYY-MM extracted from transaction_date), return the month, total number of transactions (tx_count), total amount (total_volume), and the average amount (avg_amount) rounded to 2 decimals. Sort by month.

Schema

🔑idINT
🔗account_idINT
transaction_dateTEXT
typeTEXT
amountREAL
balance_afterREAL
descriptionTEXT
reference_numberTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute