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(*)  =  1
[{'name': 'Alice'}, {'name': 'Bob'}]