SQL Detective

Case 1: The Midnight Clock

All cases

Chandpur Junction is a small railway station.

It is 14 October. The time is 23:50.

The station has a small museum room. Its old brass clock is missing.

The clock is from 1906. Everyone in the town knows it.

The station keeps records in four tables. You will read them with SQL.

We will teach you SQL one step at a time.

Chapter 1 of 9SELECT * FROM

Read the report

The station keeps its records in tables. A table has rows and columns, like a spreadsheet.

SELECT asks for columns. The star * means all columns. FROM says which table.

SELECT * FROM people;
Find
Everything in the report.
Table
Show
all columns

Loading the SQL engine…