What are the student ids of students who don't have any allergies?
CREATE TABLE Has_allergy (StuID VARCHAR); CREATE TABLE Student (StuID VARCHAR)
SELECT StuID FROM Student EXCEPT SELECT StuID FROM Has_allergy
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Has_allergy (StuID VARCHAR); CREATE TABLE Student (StuID VARCHAR) Question: What are the student ids of students who don't have any allergies? [/INST] SELECT StuID FROM Student EXCEPT SELECT StuID FROM Has_allergy </s>