What are the names of all friends who are from New York?
select t2.name from person as t1 join personfriend as t2 on t1.name = t2.friend where t1.city = 'new york city'