How many female students are there?
select count(*) from student where sex = "F"
How many have secretary votes?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = secretary_vote where t1.sex = "F"
Which of them have votes from the spring election cycle? List their names.
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = secretary_vote where t1.sex = "F" and t2.election_cycle = "Spring"
What is their average age?
select avg(t1.age) from student as t1 join voting_record as t2 on t1.stuid = secretary_vote where t1.sex = "F" and t2.election_cycle = "Spring"