CREATE TABLE VOTING_RECORD (Election_Cycle VARCHAR2)
CREATE TABLE STUDENT (StuID VARCHAR2, city_code VARCHAR2)

Find the number of students whose city code is NYC and who have class senator votes in the spring election cycle.
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"
SELECT COUNT(*) FROM "STUDENT" "T1" JOIN "VOTING_RECORD" "T2" ON "Class_Senator_Vote" = "T1"."StuID" AND "Spring" = "T2"."Election_Cycle" WHERE "NYC" = "T1"."city_code"