Table schema:
CREATE TABLE PersonFriend (name VARCHAR)

Question: Find the person who has exactly one friend.
SQL: SELECT name FROM PersonFriend GROUP BY name HAVING COUNT(*) = 1