Find the distinct Advisor of students who have treasurer votes in the spring election cycle.
create table student (advisor varchar, stuid varchar, PRIMARY KEY (advisor)); create table voting_record (treasurer_vote varchar, election_cycle varchar, PRIMARY KEY (treasurer_vote))
select distinct t1.advisor from student as t1 join voting_record as t2 on t1.stuid = t2.treasurer_vote where t2.election_cycle = "spring"