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