How many people is Zach friends with?
select count(*) from personfriend where name = 'Zach'
Who are they?
select name from personfriend where name = 'Zach'
Also show how long they have been freinds.
select name, year from personfriend where name = 'Zach'
Show the name of the person who has been freinds with him the longest.
select friend from personfriend where name = 'Zach' and year = (select max(year) from personfriend where name = 'Zach')