SELECT name FROM PersonFriend WHERE friend =  'Alice' AND YEAR  =  (SELECT min(YEAR) FROM PersonFriend WHERE friend =  'Alice')
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 = value and year = ( select min ( year ) from personfriend where friend = value )
Find the name of persons who are friends with Alice for the shortest years .