Table schema:
CREATE TABLE PersonFriend (friend VARCHAR, name VARCHAR, YEAR INTEGER)

Question: Who is the friend of Zach with longest year relationship?
SQL: SELECT friend FROM PersonFriend WHERE name = 'Zach' AND YEAR = (SELECT MAX(YEAR) FROM PersonFriend WHERE name = 'Zach')