text: CREATE TABLE artist (name VARCHAR, artist_id VARCHAR); CREATE TABLE exhibition (name VARCHAR, artist_id VARCHAR) -- Show names for artists without any exhibition. SELECT name FROM artist WHERE NOT artist_id IN (SELECT artist_id FROM exhibition) CREATE TABLE exhibition (ticket_price INTEGER); CREATE TABLE exhibition (theme VARCHAR, artist_id VARCHAR, ticket_price INTEGER); CREATE TABLE artist (name VARCHAR, artist_id VARCHAR) -- What is the theme and artist name for the exhibition with a ticket price higher than the average? SELECT T1.theme, T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id = T2.artist_id WHERE T1.ticket_price > (SELECT AVG(ticket_price) FROM exhibition) CREATE TABLE exhibition (ticket_price INTEGER, YEAR INTEGER) -- Show the average, minimum, and maximum ticket prices for exhibitions for all years before 2009. SELECT AVG(ticket_price), MIN(ticket_price), MAX(ticket_price) FROM exhibition WHERE YEAR < 2009 CREATE TABLE exhibition (theme VARCHAR, YEAR VARCHAR, ticket_price VARCHAR) -- Show theme and year for all exhibitions in an descending order of ticket price. SELECT theme, YEAR FROM exhibition ORDER BY ticket_price DESC CREATE TABLE exhibition_record (date VARCHAR, attendance VARCHAR, exhibition_id VARCHAR); CREATE TABLE exhibition (theme VARCHAR, exhibition_id VARCHAR, year VARCHAR) -- What is the theme, date, and attendance for the exhibition in year 2004? SELECT T2.theme, T1.date, T1.attendance FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T2.year = 2004