human
Schema:
artist (Artist_ID, Name, Country, Year_Join, Age)
exhibition (Exhibition_ID, Year, Theme, Artist_ID, Ticket_Price)
exhibition_record (Exhibition_ID, Date, Attendance)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the average of artist ages?
assistant
SELECT AVG ( age ) FROM artist;
human
who is the oldest artist? | do you want to show his/her name? | yes
assistant
SELECT name FROM artist ORDER by age desc LIMIT 1 ;