Tricky~27min
The Referral Rabbit
The referral bonus program paid out ₹40,000 last month to 8 users. Marketing is thrilled about organic growth. Finance noticed these 8 users all referred each other in a circle.
Tables you'll query
usersreferral_bonusestransactions
What you'll learn
CTEs (WITH clause)JOINsAggregations & GROUP BY