Query: 01/10
Lives: 3 lives left
Score: 0000
Best: --

SQL Sprint

A tiny database, a question from your boss. Snap the right query blocks together before time runs out.

SQL Sprint

Your boss has a question about a tiny table: "Which books are cooking books?", "Total sales for each region?". Snap the right query blocks into place, in the right order, and run the query. The game runs it for real and shows the rows you got.

10 queries
SQL

How to play

Read the question. The boss asks about the small table on screen: books, sales, plants or trips.
Snap the blocks. Tap a block, then a slot (or press 1 to 5). Clauses go in SQL order: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT.
Run it. Your query runs for real. Same rows as the boss wanted? You score. Some blocks are traps.
Score. 100 per right query, +20 per slot above 3 and up to 50 for speed. A wrong query or the clock costs one of 3 lives.

Quick tips

Learn the clause order. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Out of order, the query won't run.
Quote text, not numbers. genre = 'Cooking' needs quotes; price < 10 doesn't.
Read "or less" carefully. "5 days or less" is <= 5. < 5 drops the row with exactly 5.
WHERE before, HAVING after. WHERE filters rows before grouping; HAVING filters the groups, so it can use COUNT and SUM.
Top N = ORDER BY + LIMIT. Sort the way the boss asked (DESC for biggest first), then LIMIT keeps the first rows.