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