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 artists do we have?
assistant
SELECT count(*) FROM artist
human
Show all artist names 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
human
How many artists are above age 46 and joined after 1990?
assistant
SELECT count(*) FROM artist WHERE age > 46 AND year_join > 1990
human
Show all artist name, age, and country ordered by the yeared they joined.
assistant
SELECT name , age , country FROM artist ORDER BY Year_Join
human
Show all artist names and the year joined who are not from United States.
assistant
SELECT name , year_join FROM artist WHERE country != 'United States'
human
Return the name of the artist who has the latest join year.
assistant
SELECT name FROM artist ORDER BY year_join DESC LIMIT 1 ;