SELECT friend FROM PersonFriend WHERE name = 'Zach' AND YEAR = (SELECT MAX(YEAR) FROM PersonFriend WHERE name = 'Zach')
Siapakah teman Zach dengan hubungan tahun terpanjang?
CREATE TABLE PersonFriend (friend VARCHAR, name VARCHAR, YEAR INTEGER)