SQL Detective

Case 6: The Library Copy

All cases

The Old City Library in Kolkata has a rare room.

Its most famous item is a palm-leaf from 1891.

On 3 August, an expert checked it. It was real.

On 14 September, the expert came back. It was a very good .

Someone swapped it. The library keeps careful records. Find out who.

Chapter 1 of 11SELECT * FROM

Read the report

Warm-up. Read the report first.

This case has six tables. Look at each one in the Tables panel before you start.

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

Loading the SQL engine…