What are the student ids of all those who play sports?
select stuid from sportsinfo
What are the ids of all students?
select stuid from student
Which ids are in the latter list but not the former?
select stuid from student except select stuid from sportsinfo