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