human
Schema:
Person (name, age, city, gender, job)
PersonFriend (name, friend, year)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the maximum age of engineers?
assistant
SELECT MAX( age ) FROM person WHERE job = 'engineer';
human
List all information for people older than this.
assistant
SELECT * FROM person WHERE age > ( SELECT MIN( age ) FROM person WHERE job = 'engineer' );
human
Where are they all from?
assistant
SELECT city FROM person WHERE age > ( SELECT MIN( age ) FROM person WHERE job = "engineer" ) ;