Count the number of students whose city code is NYC.
select count(*) from student where city_code = "NYC"
What are their names?
select fname, lname from student where city_code = "NYC"
How many of those students have class senator votes?
select count(*) from student as t1 join voting_record as t2 on t1.stuid = class_senator_vote where t1.city_code = "NYC"
How many of those votes are from 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"