Just names
select t2.fname, t2.lname from has_allergy as t1 join student as t2 on t1.stuid = t2.stuid
How many students don't have any type of allergy?
select count ( * ) from student where stuid not in ( select t2.stuid from has_allergy as t1 join student as t2 on t1.stuid = t2.stuid )
What are their full names?
select lname, fname from student where stuid not in ( select t2.stuid from has_allergy as t1 join student as t2 on t1.stuid = t2.stuid )