Find the first and last names of all the female (sex is F) students who have president votes.
create table student (fname varchar, lname varchar, stuid varchar, sex varchar, PRIMARY KEY (fname)); create table voting_record (president_vote varchar, PRIMARY KEY (president_vote))
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"