CREATE TABLE PersonFriend (name VARCHAR, friend VARCHAR, YEAR INT)

Find the name of persons who are friends with Alice for the shortest years.
SELECT name FROM PersonFriend WHERE friend = 'Alice' AND YEAR = (SELECT MIN(YEAR) FROM PersonFriend WHERE friend = 'Alice')
SELECT "name" FROM "PersonFriend" WHERE "YEAR" = (SELECT MIN("YEAR") FROM "PersonFriend" WHERE "friend" = 'Alice') AND "friend" = 'Alice'