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
Investigate this case →