For each customer who referred someone, return referrer (name) and referred_revenue — total order value of the people they referred (0 if they didn't buy).
7 rows with columns referrer, referred_revenue — first 3 shown:
| # | ||
|---|---|---|
| 1 | Aarav Shah | 6096 |
| 2 | Kabir Singh | 11084 |
| 3 | Rohit Nair | 11579 |
Run your code to see the output here.