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