Tricky~20min

The Book Checked Out After Being Lost

8 book copies show an active checkout recorded after they were marked lost — the catalog never actually pulled them from circulation. 12 more lost copies also show a checkout scanned after the lost date, but it was cancelled right away — staff caught the scanning error immediately.

Tables you'll query

book_copiescheckouts

What you'll learn

JOINsDate & Time Functions
Investigate this case →