Task: Text to Code
Input (English): Which friend of Zach has the longest-lasting friendship?
Output (English): SELECT friend FROM PersonFriend WHERE name =  'Zach' AND YEAR  =  (SELECT max(YEAR) FROM PersonFriend WHERE name =  'Zach')