Balance at Every Order
Hard About 30 min Katabench Pro
Project an inclusive running order balance with a deterministic correlated nested query.
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
- Correlated subqueries and LATERAL
- Compute per-row results with correlated subqueries or LATERAL joins without one query per row.
- Deterministic ordering
- Make ORDER BY total with tie-breakers so limits, pages and aggregates stay stable.
Related katas
- The Order Immediately Before This One Hard Pro Correlate each order with its immediate predecessor through a translated lateral subquery.
- Two Consecutive Readings Confirm It Medium Pro Confirm alarms from adjacent high samples within a maximum gap, without skipping intervening low readings.
- Three Leaders in Every Market Hard Pro Take a bounded set of revenue leaders inside every country after a four-table aggregate.
- Back After a Real Quiet Period Hard Pro Find immediate order gaps that create reactivation episodes and summarize them per customer.