Who Stopped Listening
Medium About 20 min Katabench Pro
Set difference between two time windows with EXCEPT: dedup semantics, positional columns, and a join back for the report row.
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
- Set operations
- UNION, INTERSECT and EXCEPT, with and without ALL, and what deduplication they imply.
Related katas
- Products Both Markets Buy Medium Pro Compose two product-id queries with Intersect so Postgres returns the overlap in one statement instead of two market-sized lists.
- Here, But Never There Medium Pro Use queryable Except to find products sold in one market and absent from another without materializing either market set.
- Two Warehouses, Matching Stock Medium Pro INTERSECT returns a set and throws duplicate rows away: count matched stock units with multiset semantics instead.
- Match the Duplicate Units Medium Pro Reconcile duplicate receipt units with INTERSECT ALL instead of collapsing them to a set.