Two Consecutive Readings Confirm It
Medium About 20 min Katabench Pro
Confirm alarms from adjacent high samples within a maximum gap, without skipping intervening low readings.
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
- Balance at Every Order Hard Pro Project an inclusive running order balance with a deterministic correlated nested query.
- The Order Immediately Before This One Hard Pro Correlate each order with its immediate predecessor through a translated lateral subquery.
- Every Order at the Latest Instant Medium Pro Find each customer's latest order timestamp without throwing away other orders tied at that same instant.
- Continue After This Order Medium Pro Turn a timestamp and id cursor into a fully ordered seek predicate, so a deep page reads only the rows it returns.