Tricky~19min
The Return Mileage Less Than Pickup
8 rental agreements have a return_mileage lower than pickup_mileage with no odometer reset on file — physically impossible under normal driving, points to odometer rollback or a data-entry swap. 12 more agreements show the same pattern, but the odometer was legitimately replaced during service that day.
Tables you'll query
rental_agreements
What you'll learn
Aggregations & GROUP BY