-- Database schema
| Student : StuID [ INT ] primary_key , LName [ TEXT ] , Fname [ TEXT ] , Age [ INT ] , Sex [ TEXT ] , Major [ INT ] , Advisor [ INT ] , city_code [ TEXT ] | Voting_record : StuID [ INT ] Voting_record.StuID = Student.StuID , Registration_Date [ TEXT ] , Election_Cycle [ TEXT ] , President_Vote [ INT ] Voting_record.President_Vote = Student.StuID , Vice_President_Vote [ INT ] Voting_record.Vice_President_Vote = Student.StuID , Secretary_Vote [ INT ] Voting_record.Secretary_Vote = Student.StuID , Treasurer_Vote [ INT ] Voting_record.Treasurer_Vote = Student.StuID , Class_President_Vote [ INT ] Voting_record.Class_President_Vote = Student.StuID , Class_Senator_Vote [ INT ] Voting_record.Class_Senator_Vote = Student.StuID |
-- -- Find the distinct majors of students who have treasurer votes.

SELECT DISTINCT T1.Major FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID  =  T2.Treasurer_Vote;