SELECT name FROM PersonFriend GROUP BY name HAVING count(*)  =  1
Find the person who has exactly one friend.
SELECT name FROM PersonFriend GROUP BY name HAVING count ( * ) = 1
select name from personfriend group by name having count ( * ) = value
Find the person who has exactly one friend .