How many students have Vice President votes?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = vice_president_vote
Count the number of those students whose city code is not PIT.
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = vice_president_vote where city_code != "PIT"
Please list their names.
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote except select distinct fname, lname from student where city_code = "PIT"
Please only list their first names.
select distinct t1.fname from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote except select distinct fname from student where city_code = "PIT"