Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM Student WHERE Major = "NYC"
Feedback: student id should be used instead advisor , election cycle equals spring , student id is registered as class senator vote in voting record .
Output (English): SELECT count(*) FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID  =  Class_Senator_Vote WHERE T1.city_code  =  "NYC" AND T2.Election_Cycle  =  "Spring"