What are the student ids of students who don't have any allergies?
create table has_allergy (stuid varchar, PRIMARY KEY (stuid)); create table student (stuid varchar, PRIMARY KEY (stuid))
select stuid from student except select stuid from has_allergy