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