Summarizing Transactions with SQL | Dataford Interview Questions

Write a SQL query utilizing aggregate functions and a GROUP BY clause to summarize daily transaction volumes.

Use the provided transactions table. Exclude records without a transaction timestamp.

Output

transactions

Column	Type	Description
transaction_idPK	INTEGER	Unique transaction identifier
transaction_timestamp	TIMESTAMP	Timestamp when the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

Your question is Summarizing Transactions with SQL. Start with the requirements and the one table 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 utilizing aggregate functions and a GROUP BY clause to summarize daily transaction volumes.

Use the provided transactions table. Exclude records without a transaction timestamp.

transactions

Column	Type	Description
transaction_idPK	INTEGER	Unique transaction identifier
transaction_timestamp	TIMESTAMP	Timestamp when the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

Your question is Summarizing Transactions with SQL. Start with the requirements and the one table 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.