Cold Case~62min

The Fuel Purchases Made 270 Miles From Where The Truck Was

6 of DRV-22's fuel card transactions happened 230-310 miles from where his own GPS log placed his truck within 10-15 minutes of the purchase — $2,633.00 in fuel bought somewhere the truck demonstrably wasn't. DRV-30 also has a transaction with a large mile gap to the nearest GPS reading, but that reading is 6 hours away in time — his GPS logger was simply offline that day, not a same-time contradiction.

Tables you'll query

driversgps_logsfuel_transactions

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →