SQL: Failed Transactions in Window | Dataford Interview Questions

Write a query to identify users who have had more than three failed transaction attempts within a five-minute window.

Use the users and transaction_attempts tables. Consider only attempts whose status is failed.

Output

One row per qualifying user.
Return user_id, email, max_failed_attempts_in_5_minutes, and first_detected_at.
Sort by the maximum count descending, then user_id ascending.

users

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address

transaction_attempts

Column	Type	Description
attempt_idPK	INT	Unique transaction attempt identifier
user_id	INT	User associated with the attempt
attempted_at	TIMESTAMP	Timestamp when the attempt occurred
status	VARCHAR(50)	Outcome of the transaction attempt

Your question is SQL: Failed Transactions in Window. 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.