Who is the friend of Zach with longest year relationship?
CREATE TABLE PersonFriend (friend VARCHAR, name VARCHAR, YEAR INTEGER)
[SQL] SELECT friend FROM PersonFriend WHERE name = 'Zach' AND YEAR = (SELECT MAX(YEAR) FROM PersonFriend WHERE name = 'Zach') [/SQL]