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

What are the distinct last names of the students who have president votes and have 8741 as the advisor?
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" AS "T1" JOIN "voting_record" AS "T2" ON "T1"."stuid" = "president_vote" INTERSECT SELECT DISTINCT "lname" FROM "student" WHERE "8741" = "advisor"