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