human
Schema:
Person (name, age, city, gender, job)
PersonFriend (name, friend, year)
Please answer with SQL.
assistant
Sure, I understand.
human
What city does Alice live in?
assistant
SELECT city FROM person WHERE name = 'Alice';
human
What gender is Alice?
assistant
SELECT gender FROM person WHERE name = 'Alice';
human
What job does Bob do?
assistant
SELECT job FROM person WHERE name = 'Bob';
human
How old is Bob?
assistant
SELECT age FROM person WHERE name = 'Bob';
human
Where does he live?
assistant
SELECT city FROM person WHERE name = "Bob" ;