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
Can you list the ages of all the artists from United States?
assistant
SELECT age FROM artist WHERE country = 'United States';
human
What is the average age of all the artists from United States?
assistant
SELECT AVG ( age ) FROM artist WHERE country = 'United States';
human
Hmm, I also want to know the minimum age of all the artists from United States please.
assistant
SELECT MIN( age ) FROM artist WHERE country = "United States" ;