show student ids who are female and play football
select stuid from student where sex = 'F' intersect select stuid from sportsinfo where sportname = "Football"
yes
select fname, lname from student where stuid = 1002
what is the first name and last name of the student with the student id 1003
select fname, lname from student where stuid = 1003