Who has a friend that is from new york city?
CREATE TABLE PersonFriend (
    name VARCHAR,
    friend VARCHAR
)

CREATE TABLE Person (
    name VARCHAR,
    city VARCHAR
)
SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T1.city = 'new york city'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who has a friend that is from new york city? ### Input: CREATE TABLE PersonFriend (
    name VARCHAR,
    friend VARCHAR
)

CREATE TABLE Person (
    name VARCHAR,
    city VARCHAR
) ### Response: SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T1.city = 'new york city'