Who are the friends of Bob?
select t2.friend from person as t1 join personfriend as t2 on t1.name = t2.name where t1.name = 'Bob'