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