Monthly Customer Transaction Summary | Dataford Interview Questions

Write a SQL query using joins and aggregations to summarize customer transactions by month.

Use the customer and transaction records provided. Include only customers with at least one transaction.

Output

One row per customer and calendar month
Columns: customer_id, customer_name, transaction_month, transaction_count, and total_amount
Sort by customer_id, then transaction_month ascending

customers

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
customer_id	INT	Customer associated with the transaction
transaction_date	DATE	Date the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

Your question is Monthly Customer Transaction Summary. Start with the requirements and the two tables in the Question tab.

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 SQL query using joins and aggregations to summarize customer transactions by month.

Use the customer and transaction records provided. Include only customers with at least one transaction.

One row per customer and calendar month
Columns: customer_id, customer_name, transaction_month, transaction_count, and total_amount
Sort by customer_id, then transaction_month ascending

customers

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
customer_id	INT	Customer associated with the transaction
transaction_date	DATE	Date the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

Your question is Monthly Customer Transaction Summary. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.