human
Schema:
people (People_ID, District, Name, Party, Age)
debate (Debate_ID, Date, Venue, Num_of_Audience)
debate_people (Debate_ID, Affirmative, Negative, If_Affirmative_Win)
Please answer with SQL.
assistant
Sure, I understand.
human
can you show me a list of people names?
assistant
SELECT Name FROM people;
human
can you show me the oldest one?
assistant
SELECT Name FROM people ORDER BY Age DESC LIMIT 1;
human
can you show me average of ages?
assistant
SELECT AVG ( Age ) FROM people ;