SQL Detective

Case 3: The Missing Bat

All cases

Lakeside Cricket Club, Chennai. Today is the final of the club tournament.

Lakeside plays Harbour. Each team has 6 players.

The club's oldest bat sits in a glass case in the clubhouse. The 1975 team signed it.

The match starts at 14:00. At 17:30, the captains come in for the prize.

The glass case is empty.

Chapter 1 of 10SELECT * FROM

Read the report

Warm-up. Start every case by reading the report.

Then look at the other tables in the Tables panel. Tap a table to see its rows.

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

Loading the SQL engine…