Find the distinct last names of all the students who have president votes and whose advisor is 8741.
CREATE TABLE STUDENT (
    LName VARCHAR,
    PRESIDENT_Vote VARCHAR,
    Advisor VARCHAR
)

CREATE TABLE VOTING_RECORD (
    Id VARCHAR
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the distinct last names of all the students who have president votes and whose advisor is 8741. ### Input: CREATE TABLE STUDENT (
    LName VARCHAR,
    PRESIDENT_Vote VARCHAR,
    Advisor VARCHAR
)

CREATE TABLE VOTING_RECORD (
    Id VARCHAR
) ### Response: 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"