SELECT friend FROM PersonFriend WHERE name =  'Zach' AND YEAR  =  (SELECT max(YEAR) FROM PersonFriend WHERE name =  'Zach')
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 ' )
select friend from personfriend where name = value and year = ( select max ( year ) from personfriend where name = value )
Who is the friend of Zach with longest year relationship ?