human
Schema:
festival_detail (Festival_ID, Festival_Name, Chair_Name, Location, Year, Num_of_Audience)
artwork (Artwork_ID, Type, Name)
nomination (Artwork_ID, Festival_ID, Result)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me everything about all the artworks.
assistant
SELECT * FROM artwork;
human
List only the names of all these artworks.
assistant
SELECT name FROM artwork;
human
Which of these were nominated?
assistant
SELECT t1.name FROM artwork AS t1 JOIN nomination AS t2 ON t1.artwork_id = t2.artwork_id JOIN festival_detail AS t3 ON t2.festival_id = t3.festival_id;
human
Which of those weren't?
assistant
SELECT Name FROM Artwork WHERE Artwork_ID NOT IN ( SELECT Artwork_ID FROM nomination ) ;