SELECT name FROM PersonFriend GROUP BY name HAVING count(*)  =  1
What are the names of everybody 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
What are the names of everybody who has exactly one friend ?