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