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
Show all info about exhibitions.
assistant
SELECT * FROM exhibition;
human
Which exhibitions were before year 2009?
assistant
SELECT * FROM exhibition WHERE YEAR < 2009;
human
What are their average ticket prices?
assistant
SELECT AVG ( ticket_price ) FROM exhibition WHERE YEAR < 2009;
human
Can you also show their minimum, and maximum ticket prices?
assistant
SELECT AVG ( ticket_price ) , MIN( ticket_price ) , MAX( ticket_price ) FROM exhibition WHERE YEAR < 2009 ;