Instagram Growth wants to identify which referrers are driving the most new account signups in the last 30 days. Write a SQL query to return the top 3 referrers by number of signups.
signup_date falls within the last 30 days relative to DATE '2024-06-30'.referral_events using referred_user_id.NULL.referrer_name, signup_count.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| full_name | VARCHAR(100) | User's display name |
| signup_date | DATE | Date the user signed up |
| Column | Type | Description |
|---|---|---|
| referral_idPK | INT | Unique referral event identifier |
| referred_user_id | INT | User who signed up from a referral |
| referrer_name | VARCHAR(100) | Name of the referrer source or partner |
| referrer_surface | VARCHAR(50) | Meta surface where the referral originated |