CREATE TABLE Sportsinfo (StuID VARCHAR2)
CREATE TABLE Student (StuID VARCHAR2)

Show student ids who don't have any sports.
SELECT StuID FROM Student EXCEPT SELECT StuID FROM Sportsinfo
SELECT "StuID" FROM "Student" EXCEPT SELECT "StuID" FROM "Sportsinfo"