Fraud Detection Window Query | Dataford Interview Questions

Given a transaction table, write a query to detect potential fraud by identifying accounts that performed more than three transactions within a five-minute window for Idfc First Bank.

Use the transactions table. Treat transactions exactly five minutes apart as part of the same window.

Output

One row per qualifying account and five-minute window
Columns: account_id, window_start, window_end, and transaction_count
Sort by account_id, then window_start ascending

Schema

transactions

Column	Type	Description
transaction_idPK	BIGINT	Unique transaction identifier
account_id	VARCHAR(20)	Idfc First Bank account identifier
transaction_ts	TIMESTAMP	Timestamp when the transaction occurred
amount	NUMERIC(12,2)	Transaction amount in Indian rupees

Your question is Fraud Detection Window Query. 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