CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

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')
SELECT "friend" FROM "personfriend" WHERE "name" = 'Zach' AND "year" = (SELECT MAX("year") FROM "personfriend" WHERE "name" = 'Zach')