JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Monthly Transaction Volume by Account Type | Algorithm

Mediumdate-bucketingSQL

Monthly Transaction Volume by Account Type

The finance team wants to understand how transaction activity varies by account type and month to identify trends in customer usage. They need a report that shows the total number of transactions and the sum of transaction amounts for each account type, broken down by month (using the transaction date).

Return

account_type : the type of account (from accounts) month : the year and month of the transaction (format 'YYYY-MM') transaction_count : number of transactions for that account type and month total_amount : sum of amount for that account type and month Return only rows where transaction_count is greater than zero, ordered by account_type and month ascending.

Expected output

account_type	month	transaction_count	total_amount
2 rows — values hidden, that's the puzzle

Your query should return 2 rows with these columns. Your column aliases don't need to match.

Ctrl+Enter to run

Run your query to see results here.