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 exhibitions in 2004.
assistant
SELECT * FROM exhibition WHERE year = 2004;
human
Show all artists.
assistant
SELECT name FROM artist;
human
Show all the names of the artists who didn't have an exhibition in 2004.
assistant
SELECT name FROM artist EXCEPT SELECT T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id = T2.artist_id WHERE T1.year = 2004 ;