How many students have vice President votes?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote
What are their names?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote
How many of them are 18 years old?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote where t1.age = 18
What are their first and last names?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.vice_president_vote where t1.age = 18