Task: Text to Code
Input (English): Step 1: For each row in Person table, find the corresponding rows in PersonFriend table.
Step 2: find without repetition Person's name, age of the results of step 1 whose job equals Dan or friend equals Alice
Output (English): SELECT DISTINCT T1.name , T1.age FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.name WHERE T1.job = "Dan" OR T2.friend = "Alice"