Cold Case~66min
The Expiry Dates That Were Extended After They Already Passed
5 lots (L-3001 through L-3005) had their expiry date extended by the same reviewer, QA-REV-3, 14 to 26 days AFTER the original expiry date had already passed, then shipped within days of the extension. Those 5 lots generated 17 complaints afterward, versus a near-zero background complaint rate on lots that were never re-dated. Lot L-4010 also has an expiry_update, but it was requested 60 days BEFORE the original expiry — a proactive stability-testing extension, reviewed by a different QA reviewer (QA-REV-7), and generated zero complaints.
Tables you'll query
lotsexpiry_updatesshipmentscomplaints
What you'll learn
JOINsAggregations & GROUP BYDate & Time Functions