Show the name of students
select lname, fname from student
How many of them live in city with code NYC and have secretary votes in the spring election cycle
select count ( distinct t1.stuid ) from student as t1 join voting_record as t2 on t1.stuid = secretary_vote where t1.city_code = "NYC" and t2.election_cycle = "Spring"
Show the name of this student
select t1.lname, t1.fname from student as t1 join voting_record as t2 on t1.stuid = secretary_vote where t1.city_code = "NYC" and t2.election_cycle = "Spring"