Task: Text to Code
Input (English): Who has a friend that is from new york city?
Output (English): SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name  =  T2.friend WHERE T1.city  =  'new york city'