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