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

What are the names of all people who are friends with Alice for the shortest amount of time?
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')