Who has a friend that is from new york city?
select t2.name from person as t1 join personfriend as t2 on t1.name = t2.friend where t1.city = 'new york city'