Tricky~25min

The Gift Card Loop

One account has ₹46,200 in orders. ₹5,500 of it was covered by gift cards that trace back to a referral program that should never have paid out. Gift cards were involved. And then it just kept going.

Tables you'll query

customersreferralsgift_cardsorders

What you'll learn

SubqueriesJOINsDate & Time Functions
Investigate this case →