How many people does Bob consider a friend?
select count(*) from personfriend where name = 'Bob'
How long have they been friends?
select friend, year from personfriend where name = 'Bob'
Only show the name.
select friend from personfriend where name = 'Bob'