yes
select stuid from student where sex = 'F'
now give me the student ids of people who play football
select stuid from sportsinfo where sportname = "Football"
show me the ids of the students that are both female and play football
select stuid from student where sex = 'F' intersect select stuid from sportsinfo where sportname = "Football"