SQL Detective

Case: The Midnight Clock

Chandpur Junction, 14 October, just before midnight.

The station's 1906 brass clock, the pride of its little museum room, has vanished.

The station keeps its records in four tables: report, people, gate_log and vehicles. You'll read them with SQL, and we'll teach you how as you go.

Chapter 1 of 8SELECT * FROM

Read the report

The station's records are kept in tables. Each table has rows and columns, like a spreadsheet.

SELECT asks for columns. * means "all of them". FROM names the table.

SELECT * FROM people;

Start with the incident report. Show everything in the report table.

Loading the SQL engine…