Find the number of students whose city code is NYC, please?
select count ( * ) from student as t1 join voting_record as t2 on t1.stuid = class_senator_vote where t1.city_code = "NYC"
What is the number of students 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 t2.election_cycle = "Spring"
What are the first names and last names of those students?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = class_senator_vote where t2.election_cycle = "Spring"