CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE voting_record (stuid NUMBER, registration_date CLOB, election_cycle CLOB, president_vote NUMBER, vice_president_vote NUMBER, secretary_vote NUMBER, treasurer_vote NUMBER, class_president_vote NUMBER, class_senator_vote NUMBER)

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"
SELECT DISTINCT "T1"."lname" FROM "student" "T1" JOIN "voting_record" "T2" ON "T1"."stuid" = "president_vote" INTERSECT SELECT DISTINCT "lname" FROM "student" WHERE "8741" = "advisor"