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
Investigate this case →