Find the name of persons who are friends with Alice for the shortest years.
CREATE TABLE PersonFriend (name VARCHAR, friend VARCHAR, YEAR INTEGER)
SELECT name FROM PersonFriend WHERE friend = 'Alice' AND YEAR = (SELECT MIN(YEAR) FROM PersonFriend WHERE friend = 'Alice')
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE PersonFriend (name VARCHAR, friend VARCHAR, YEAR INTEGER) Question: Find the name of persons who are friends with Alice for the shortest years. [/INST] SELECT name FROM PersonFriend WHERE friend = 'Alice' AND YEAR = (SELECT MIN(YEAR) FROM PersonFriend WHERE friend = 'Alice') </s>