CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE voting_record (stuid NUMBER, registration_date CLOB, election_cycle CLOB, president_vote NUMBER, vice_president_vote NUMBER, secretary_vote NUMBER, treasurer_vote NUMBER, class_president_vote NUMBER, class_senator_vote NUMBER)

Which students live in the city with code 'NYC' and have class senator votes in the spring election cycle? Count the numbers.
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 "Spring" = "T2"."election_cycle" AND "T1"."stuid" = "class_senator_vote" WHERE "NYC" = "T1"."city_code"