Show ids of all students who do not have any friends.
CREATE TABLE Highschooler (id VARCHAR, student_id VARCHAR); CREATE TABLE Friend (id VARCHAR, student_id VARCHAR)
SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Highschooler (id VARCHAR, student_id VARCHAR); CREATE TABLE Friend (id VARCHAR, student_id VARCHAR) Question: Show ids of all students who do not have any friends. [/INST] SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend </s>