More SQL Please: JOIN (Tables)

| id | referrer_id | name_first | name_last | email_address | |----|-------------|------------|-----------|---------------------------| | 1 | 2 | Marcus | Crawford | marcus@mcrawford.ca | | 2 | NULL | Elena | Moreno | elena@hellocorp.com | | 3 | NULL | Simon | Chen | simon@sqlanalytics.io | | 4 | 5 | Priya | Amini | priya@aminiconsulting.com | | 5 | NULL | Zara | Amini | zara@aminiconsulting.com |

| id | user_id | charity_id | date | amount | |----|---------|------------|---------------------|--------| | 1 | 1 | 1 | 2024-04-12 09:10:01 | 20 | | 2 | 3 | 2 | 2024-04-19 12:40:15 | 10 | | 3 | 5 | 3 | 2024-05-01 19:51:45 | 40 | | 4 | 2 | 3 | 2024-05-03 14:09:11 | 75 | | 5 | 99 | 1 | 2024-06-01 01:11:44 | 100 |

| id | name | |----|-----------------| | 1 | Homes for Pets | | 2 | Ocean Life | | 3 | Learning Ladder |