CREATE TABLE personfriend (name CLOB, friend CLOB, year NUMBER)
CREATE TABLE person (name CLOB, age NUMBER, city CLOB, gender CLOB, job CLOB)

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')