SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name  =  T2.friend WHERE T1.city  =  'new york city'
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 '
select t2 . name from person as t1 join personfriend as t2 on t1 . name = t2 . friend where t1 . city = value
What are the names of all friends who are from New York ?