CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)
CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)

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 "friend" = 'Alice' AND "year" = (SELECT MIN("year") FROM "personfriend" WHERE "friend" = 'Alice')