Who has the shortest relationship among the people Zach is friends with?
select name from personfriend where name = 'Zach' order by year limit 1
How about the longest?
select name from personfriend where name = 'Zach' order by year desc limit 1
Also show how long have they been freinds.
select name, year from personfriend where name = 'Zach' order by year desc limit 1
How old are they?
select t1.age from person as t1 join personfriend as t2 on t1.name = t2.friend where t2.name = 'Zach' and t2.year = (select max(year) from personfriend where name = 'Zach')