Who is the friend of Zach with longest year relationship?
select friend from personfriend where name = 'Zach' and year = (select max(year) from personfriend where name = 'Zach')