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