Busiest Hour for Transactions | Dataford Interview Questions

Write a SQL query to identify the busiest hour of the day for transactions.

Use the transaction timestamp to determine the hour. Exclude records without a timestamp and return every hour tied for the highest transaction count.

Output

One row per busiest hour
Columns: transaction_hour and transaction_count
Return the hour as an integer from 0 through 23
Order tied results by transaction_hour ascending

Schema

transactions

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

Your question is Busiest Hour for Transactions. 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.

Problem