Cold Case~60min

The Driver Whose Truck Was Always Lighter Than It Really Was

Driver DRV-14 logged a tare (empty truck) weight 900-1,300 lbs below the actual certified tare weight on 6 tickets, across 3 different trucks — inflating the billable net weight on every one. That's 6,450 lbs (3.225 tons) of fabricated waste weight, worth $154.80 in inflated tipping fees at $48/ton. Because it follows the driver across different trucks rather than staying with one truck, it can't be a scale calibration issue. TRK-07's recorded tare also varies by up to 250 lbs across different drivers, but that's normal fuel-level variance on a single truck, not under-recording tied to one person.

Tables you'll query

trucksweigh_tickets

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →