CREATE TABLE Person (name VARCHAR(255), city VARCHAR(255)); CREATE TABLE PersonFriend (name VARCHAR(255), friend VARCHAR(255))
Who has a friend that is from new york city?
    
SQL: SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T1.city = 'new york city'