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 highest age of the the Artists from the United States?
assistant
SELECT MAX( age ) FROM artist WHERE country = 'United States';
human
How many artists from the USA joined after 1993?
assistant
SELECT COUNT( Artist_ID ) FROM artist WHERE country = "United States" AND Year_Join > 1993 ;