How many students have treasurer votes?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = t2.treasurer_vote
How many of those are from the spring election cycle?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = t2.treasurer_vote where t2.election_cycle = "Spring"
Please list their names.
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.treasurer_vote where t2.election_cycle = "Spring"
Who are their advisors?
select distinct t1.advisor from student as t1 join voting_record as t2 on t1.stuid = t2.treasurer_vote where t2.election_cycle = "Spring"