SQL Detective

Case 7: The Night Train

All cases

The Night Queen Express leaves Mumbai at 21:30. It reaches Hyderabad in the morning.

Ishita Varghese is an engineer. She sleeps in B2, 23.

Her laptop has new chip designs. It is in her bag, under the .

At 23:30 she falls asleep. At 05:30 she wakes up.

The bag is open. The laptop is gone.

Chapter 1 of 12SELECT * FROM

Read the report

Warm-up. Read the report first.

Times here have a date and a time, like '2026-03-14 04:20'. The night crosses midnight.

SELECT * FROM people WHERE coach = 'B2';
Find
Everything in the report.
Table
Show
all columns

Loading the SQL engine…