Find the distinct last names of all the students who have president votes and whose advisor is 8741
SELECT DISTINCT T1.LName FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID   =   PRESIDENT_Vote INTERSECT SELECT DISTINCT LName FROM STUDENT WHERE Advisor   =   "8741"
distinct last names = DISTINCT(LName); students who have president votes = JOIN on STUDENT.StuID = VOTING_RECORD.PRESIDENT_Vote; whose advisor is 8741 = WHERE Advisor = '8741';