SQL Detective

Scrivi query SQL per risolvere enigmi investigativi. Tie-in con i quiz database e il query-analyzer.

2DIntermediateSingle Player

How to Play

  1. Read the case clue and the table preview, then write a SQL query (SELECT/WHERE/JOIN/GROUP BY) that returns the requested rows.
  2. Your answer is compared as a set: row order does not matter, but the rows must be exact.
  3. On mobile tap the suggested rows/columns; on desktop use the keyboard to compose the query.
  4. Solve the case in the fewest attempts to maximise your score.
Touch controls
Keyboard Controls