SQL for High-Value Rolling Window | Dataford Interview Questions

Write a SQL query to identify users who have executed more than five transactions exceeding $10,000 within a rolling 24-hour window.

Use the transactions table. Treat the 24-hour interval as inclusive of both endpoints.

Output

Return one row per qualifying user with user_id, max_transactions_in_24h, and qualifying_window_end.
Include only users whose maximum count exceeds five. Sort by user_id ascending.

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	Identifier of the user who executed the transaction
transaction_ts	TIMESTAMPTZ	Timestamp when the transaction was executed
amount	NUMERIC(12,2)	Transaction amount in US dollars

Your question is SQL for High-Value Rolling Window. 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 to identify users who have executed more than five transactions exceeding $10,000 within a rolling 24-hour window.

Use the transactions table. Treat the 24-hour interval as inclusive of both endpoints.

Return one row per qualifying user with user_id, max_transactions_in_24h, and qualifying_window_end.
Include only users whose maximum count exceeds five. Sort by user_id ascending.

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	Identifier of the user who executed the transaction
transaction_ts	TIMESTAMPTZ	Timestamp when the transaction was executed
amount	NUMERIC(12,2)	Transaction amount in US dollars

Your question is SQL for High-Value Rolling Window. 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.