Can you show me the student names with ids?
select stuid, lname, fname from student
Hmm, can you list the student ids with sports played?
select stuid ,sportname from sportsinfo
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 )