Routine~14min

The Dead Promo Still Working

A 50% off promo code was deactivated 3 months ago. It was deactivated in the right table. But it's been used 67 times since. The checkout system reads from a different table — and nobody updated that one.

Tables you'll query

promo_codespromo_rulesorders

What you'll learn

JOINsSELECT & Filtering
Investigate this case →