Back After a Real Quiet Period
Hard About 35 min Katabench Pro
Find immediate order gaps that create reactivation episodes and summarize them per customer.
The full brief is part of Katabench Pro
Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Customer Order Totals, which is free.
How it is graded
Your LINQ or SQL runs against real PostgreSQL. You see the SQL your code generates on the sample tests and can inspect its execution plan, so you learn when the database did the wrong work.
What it practices
- Gaps and islands
- Group consecutive runs such as streaks and sessions by detecting the breaks between them.
- Correlated subqueries and LATERAL
- Compute per-row results with correlated subqueries or LATERAL joins without one query per row.
Do these first
Related katas
- Three Leaders in Every Market Hard Pro Take a bounded set of revenue leaders inside every country after a four-table aggregate.
- Balance at Every Order Hard Pro Project an inclusive running order balance with a deterministic correlated nested query.
- One Query per Row Hard Pro Collapse correlated SELECT-list subqueries into one grouped join: the N+1 that hides inside a single statement.
- The Touch Must Precede This Conversion Hard Pro Attribute each conversion to its last eligible campaign touch using a conversion-relative window and deterministic tie break.