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
how many exhibition are presented on the table
assistant
SELECT COUNT( * ) FROM exhibition;
human
ok fine then list out the artists name
assistant
SELECT name FROM artist;
human
what is the age of Vijay Singh
assistant
SELECT age FROM artist WHERE name = 'Vijay Singh';
human
what is the highest ticket price on the table
assistant
SELECT ticket_price FROM exhibition ORDER by ticket_price desc LIMIT 1 ;