Which friend of Zach has the longest-lasting friendship?
select friend from personfriend where name = 'Zach' and year = (select max(year) from personfriend where name = 'Zach')