Repeated Transactions
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
A fraud model flags duplicate charges. In the transactions table, for each user and product combination ordered by time, compare each transaction to the one immediately before it. If the amounts match and the time gap is 10 minutes or less, flag it as a repeated transaction. Return the count of such repeated transactions.
Summary
Detect same amount transactions within 10 minutes.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision