Which students have president votes?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote
How many of those students do not have advisor 2192?
select count(distinct t1.stuid) from student as t1 join voting_record as t2 on t1.stuid = t2.president_vote where t1.advisor != "2192"
What are their names?
select distinct t1.fname, t1.lname from student as t1 join voting_record as t2 on t1.stuid = president_vote except select distinct fname, lname from student where advisor = "2192"
Please only list last names.
select distinct t1.lname from student as t1 join voting_record as t2 on t1.stuid = president_vote except select distinct lname from student where advisor = "2192"