name of all the persons
select name from person
Who has a friend 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'