What are the names of everybody who has exactly one friend?
select name from personfriend group by name having count(*) = 1