Use a SQL self join to pair users with their referrers while labeling organic signups without a referral.
