Routine~11min

The Self-Referral

Marketing wants to audit the referral programme before the next payout cycle. Find any customers who used their own referral code to claim the sign-up bonus — the form didn't validate ownership, so it was technically possible.

Tables you'll query

customersreferral_uses

What you'll learn

JOINs
Investigate this case →