Cold Case~58min

The Inspector Whose Grade A Never Survived The Retest

Inspector INSP-05 declared 7 deliveries from FARM-12 as grade_a — but the independent lab retest on every single one of those 7 came back grade_b. At $50/ton more for grade_a than grade_b, FARM-12 was overpaid $6,900.00 across 138.0 tons. Inspector INSP-09 also grades generously, declaring grade_a on 5 deliveries from FARM-20, but the lab retest agrees with grade_a on all 5 — genuinely high-quality grain, not inflation.

Tables you'll query

deliveriesquality_testslab_retests

What you'll learn

JOINsAggregations & GROUP BYString Functions
Investigate this case →