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