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 ticket price of each exhibition?
assistant
SELECT ticket_price FROM exhibition;
human
Sort exhibitions in a descending order of ticket price.
assistant
SELECT * FROM exhibition ORDER BY ticket_price DESC ;