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