human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Voting_record (StuID, Registration_Date, Election_Cycle, President_Vote, Vice_President_Vote, Secretary_Vote, Treasurer_Vote, Class_President_Vote, Class_Senator_Vote)
Please answer with SQL.
assistant
Sure, I understand.
human
How many students are voting in the spring election cycle?
assistant
SELECT COUNT( * ) FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID = SECRETARY_Vote WHERE T2.Election_Cycle = 'Spring';
human
How many are females that are voting in the election cycle ? | Did you want the number of females that are voting in the spring election cycle? | Yes
assistant
SELECT COUNT( * ) FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID = SECRETARY_Vote WHERE T1.Sex = 'F' AND T2.Election_Cycle = 'Spring';
human
What are the ages of everyone voting in the Spring election cycle ?
assistant
SELECT T1.Age FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID = SECRETARY_Vote WHERE T2.Election_Cycle = "Spring" ;