Show student ids who don't have any sports.
create table sportsinfo (stuid varchar, PRIMARY KEY (stuid)); create table student (stuid varchar, PRIMARY KEY (stuid))
select stuid from student except select stuid from sportsinfo