human
Schema:
journal (Journal_ID, Date, Theme, Sales)
editor (Editor_ID, Name, Age)
journal_committee (Editor_ID, Journal_ID, Work_Type)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the names of editors of age 24.
assistant
SELECT Name FROM editor WHERE Age = 24;
human
Please show me the names of editors of age 25.
assistant
SELECT Name FROM editor WHERE Age = 25;
human
hmmm. Can you also show me the name and age of the oldest editor?
assistant
SELECT Name , age FROM editor WHERE Age = ( SELECT MAX( age ) FROM editor ) ;