Task: Text to Code
Input (English): SQL: SELECT name , age , city FROM Person ORDER BY age Desc LIMIT 1
Feedback: Only need to make sure these persons are friends with Alice for largest time .
Output (English): SELECT T1.name ,  T1.age ,  T1.job FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name  =  T2.name WHERE T2.friend =  'Alice' AND T2.year  =  (SELECT max(YEAR) FROM PersonFriend WHERE friend =  'Alice')