@billysu said in My First SQL Solution, comments welcomed:

select c1.name
from customer c1
left join customer c2
on c1.referee_id = c2.id
where c2.name <> 'Jane' or c1.referee_id is NULL

Seem a small problem here
WHERE c2.name <> 'Jane' OR c2.name is NULL;