Home
/
Questions
/
Coding
/
Longest consecutive overdraft streak per account
caseSQL
Coding question · Time Series
Medium
Asked at Plaid
Longest consecutive overdraft streak per account
Gap-and-island via row-number difference to collapse consecutive runs into groups.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Top 3 debits per customer (DENSE_RANK)
Next →
Duplicate-charge pairs within 60 seconds