Who is the person that has no friend?
CREATE TABLE PersonFriend (name VARCHAR); CREATE TABLE person (name VARCHAR)
SELECT name FROM person EXCEPT SELECT name FROM PersonFriend
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE PersonFriend (name VARCHAR); CREATE TABLE person (name VARCHAR) Question: Who is the person that has no friend? [/INST] SELECT name FROM person EXCEPT SELECT name FROM PersonFriend </s>