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.

Loading game…

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.

3 more tips in the SQL Sprint guide →