Routine~11min

The Double Checkout

IT asset management shows some equipment checked out to two people simultaneously — neither returned it before the second booking went through. A race condition in the booking form allowed both requests to pass the availability check. Find which assets are double-booked.

Tables you'll query

assetsasset_loans

What you'll learn

Aggregations & GROUP BY
Investigate this case →