What is the length of the shortest friendship?
select min(year) from personfriend
WHat is the minimum among friendships with Alice?
select min(year) from personfriend where friend = 'Alice'
What is the name of the person who has held this friendship?
select name from personfriend where friend = 'Alice' and year = (select min(year) from personfriend where friend = 'Alice')