Cold Case~62min

The Recall That Should Have Happened Sooner

14 defect reports across 4 plants all reference the same supplier lot — but the lot number was typed inconsistently into a free-text field ("LOT-4471", "lot 4471", "Batch#4471") and every plant used a different symptom label. Normalizing the text and matching it to supplier_shipments traces all 14 to one shipment from Supplier SUP-09. 9 more reports mention a lot number too, but trace to a completely different, already-resolved lot.

Tables you'll query

plantssupplier_shipmentsdefect_reports

What you'll learn

JOINsString FunctionsAggregations & GROUP BY
Investigate this case →