Show all male student ids who don't play football.
create table sportsinfo (stuid varchar, sex varchar, sportname varchar, PRIMARY KEY (stuid)); create table student (stuid varchar, sex varchar, sportname varchar, PRIMARY KEY (stuid))
select stuid from student where sex = 'm' except select stuid from sportsinfo where sportname = "football"