show me the name of persons | The names of persons are Alice, Bob, Dan and Zach | 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'
persons with a friend from New York refers to joining two tables where one table has city information and the other has friend relationships; names of persons are attributes to be selected;