human
Schema:
Person (name, age, city, gender, job)
PersonFriend (name, friend, year)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the names | Do you mean the name of all the person? | name of all the persons
assistant
SELECT name FROM Person;
human
show me the name of persons | The names of persons are Alice, Bob, Dan and Zach | Who has a friend from New York?
assistant
SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T1.city = "new york city" ;