Task: Text to Code
Input (English): Step 1: For each row in Student table, find the corresponding rows in Voting_record table.
Step 2: find without repetition LName of the results of step 1 whose Advisor equals 8741 and Secretary_Vote equals 1010
Output (English): SELECT DISTINCT T1.LName FROM Student AS T1 JOIN Voting_record AS T2 ON T1.StuID = T2.StuID WHERE T1.Advisor = 8741 AND T2.Secretary_Vote = 1010