Find the person who has exactly one friend.
CREATE TABLE PersonFriend (name VARCHAR)
SELECT name FROM PersonFriend GROUP BY name HAVING COUNT(*) = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE PersonFriend (name VARCHAR) Question: Find the person who has exactly one friend. [/INST] SELECT name FROM PersonFriend GROUP BY name HAVING COUNT(*) = 1 </s>