human
Schema:
architect (id, name, nationality, gender)
bridge (architect_id, id, name, location, length_meters, length_feet)
mill (architect_id, id, location, name, type, built_year, notes)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the nationality of Zaha Hadid?
assistant
SELECT nationality FROM architect WHERE name = 'Zaha Hadid';
human
What is the gender of Frank Gehry?
assistant
SELECT gender FROM architect WHERE name = 'Frank Gehry';
human
What is the built year of architect id 2?
assistant
SELECT built_year FROM mill WHERE architect_id = 2 ;