Case board

Hollowbrook

A quiet village with a talent for mysteries, from a missing pie to a vanished lantern.

Case No. 1
The Pie That Walked Away
A champion pumpkin pie vanishes from the village hall kitchen twenty minutes before judging.
Hollowbrook Village Hall · Saturday 13 September
Difficulty
- SELECT
- WHERE
- ORDER BY
- LIMIT
Free · no sign-up
Case No. 2
The Overdue Almanack
Hollowbrook's 1702 Almanack has been swapped for the library's own facsimile. Someone did their homework.
Hollowbrook Library · Thursday 9 October
Difficulty
- LIKE
- IN
- BETWEEN
- NULL
- COUNT / GROUP BY / HAVING
Free
Case No. 3
The Great Marrow Sabotage
On the eve of the Giant Vegetable Show, someone crept into the allotments and snipped the two biggest marrows.
Hollowbrook Community Allotments · Saturday 18 October
Difficulty
- JOIN
- multi-table JOINs
- join conditions with dates
- aliases
Full case files
Case No. 4
The Raffle That Rigged Itself
The Grand Raffle's winning ticket belongs to Elsie Sparrow. The raffle laptop disagrees.
The Halloween Fête on Hollowbrook Green · Friday 31 October
Difficulty
- subqueries
- correlated subqueries
- WITH (CTEs)
- audit trails
Full case files
Case No. 5
The Midnight Bell
Thirteen strikes at midnight, and St Wendreda's copper fox weathervane is gone. Every clock in the case disagrees.
St Wendreda's Church · Sunday 2 November
Difficulty
- date/time functions
- time zones and formats
- self-joins
- window functions (LAG, LEAD)
Full case files
Case No. 6
The Lantern of Hollowbrook
On Lantern Night, the town's 1702 Founders' Lantern vanishes from its case. Everyone suspects the newcomer.
Hollowbrook Museum, Lantern Night · Saturday 15 November
Difficulty
- everything: JOINs, subqueries, CTEs
- window functions over NULLs
- audit history
- renamed people
- date and time
Full case files