Tricky~22min

The Promo Gap

Diwali Sale ran Oct 1–31. 20% off all orders. Customer complaints started Oct 3: "I checked out during the sale but got no discount." Support says the promo was applied correctly. It wasn't — for 1,247 orders.

Tables you'll query

promotionscart_itemsorders

What you'll learn

SubqueriesJOINsDate & Time Functions
Investigate this case →