Tricky~25min
The Loyalty Cliff
Loyalty point redemptions spiked 9x in the last two weeks of November. Marketing thinks it's a sign of high engagement and wants to double the points program budget. Finance has a different read. (Points redeem at ₹1 each.)
Tables you'll query
memberspoints_ledger
What you'll learn
SubqueriesDate & Time FunctionsAggregations & GROUP BY