SELECT StuID FROM Student WHERE sex  =  'F' INTERSECT SELECT StuID FROM Sportsinfo WHERE sportname  =  "Football"
What are the ids of all female students who play football?
SELECT StuID FROM Student WHERE sex = 'F ' INTERSECT SELECT StuID FROM Sportsinfo WHERE sportname = `` Football ''
select stuid from student where sex = value intersect select stuid from sportsinfo where sportname = value
What are the ids of all female students who play football ?