DetectiveZ — Query the database, follow the clues, name the culprit.

How to play DetectiveZ

1. 1Read the case file — something went wrong at ZAK Academy.
2. 2Write SQL queries against the case database to find clues.
3. 3Each clue unlocks the next part of the story.
4. 4Run the final query that proves it, then accuse the culprit. Fewer queries, better rank.

What it trains

SQL SELECT, WHERE, ORDER BY, JOIN, COUNT/SUM and GROUP BY (2210 §9, 9618 §8.3).