Please show me how many female students have the major 600
select count ( * ) from student where sex = 'F' and major = 600
How many female students are there total?
select count ( * ) from student where sex = 'F'
How many of these women are under 25 years old?
select count ( * ) from student where sex = 'F' and age < 25
Show me the ages of the 9 female students with ages under 25 years.
select age from student where sex = 'F' and age < 25
Of all the students under 25, how many are female?
select count ( * ) from student where sex = 'F' and age < 25
What are the names of the female students that are under 25?
select fname,lname from student where sex = 'F' and age < 25