Find the person who has exactly one friend.
select name from personfriend group by name having count(*) = 1