I want to know the student names and ids who don’t play any sports.
SELECT StuID,LName,Fname FROM Student where stuID not in  ( SELECT StuID FROM Sportsinfo ) 
students who don’t play any sports are identified by stuID not in (SELECT StuID FROM Sportsinfo); student names and ids refer to LName, Fname, and StuID from the Student table;