What are the ids of all female students?
select stuid from student where sex = 'F'
What are the student ids of all those who play football?
select stuid from sportsinfo where sportname = "Football"
What ids are for both?
select stuid from student where sex = 'F' intersect select stuid from sportsinfo where sportname = "Football"