Database: network_2
Question: Find the name of persons who are friends with Alice for the shortest years.
SQL:
SELECT name FROM PersonFriend WHERE friend =  'Alice' AND YEAR  =  (SELECT min(YEAR) FROM PersonFriend WHERE friend =  'Alice')