how many females have president votes?
select count ( * ) from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.sex = "F"
what are there first and last names?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.sex = "F"
the total votes
select sum ( t2.president_vote ) from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.sex = "F"
how many of those votes were from the secretary?
select sum ( t2.secretary_vote ) from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.sex = "F"
how many were from the vice president?
select sum ( t2.vice_president_vote ) from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.sex = "F"