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 Fname, LName of the results of step 1 whose Advisor equals 18 and President_Vote equals 1004
Output (English): SELECT DISTINCT T1.Fname , T1.LName FROM Student AS T1 JOIN Voting_record AS T2 ON T1.StuID = T2.StuID WHERE T1.Advisor = 18 AND T2.President_Vote = 1004