CREATE TABLE person (name CLOB, age NUMBER, city CLOB, gender CLOB, job CLOB)
CREATE TABLE personfriend (name CLOB, friend CLOB, year NUMBER)

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')