Task: Text to Code
Input (English): Step 1: For each row in Person table, find the corresponding rows in PersonFriend table.
Step 2: find friend of the results of step 1 whose job equals Alice and gender equals female
Output (English): SELECT T2.friend FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.name WHERE T1.job = "Alice" AND T1.gender = "female"