Practice Stripe SQL Question | Real Coding Interviews

Quick Summary

Identify transactions where the same merchant, card, and amount appear multiple times.
Filter for duplicate events that occur within a ten-minute window relative to their immediate predecessor.
Count only the subsequent occurrences, excluding the initial transaction in each sequence.

What This Tests

Common Patterns

Window Function

Date Arithmetic

Aggregation

Sort

Test Cases

Input

Output

Expected