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
List the name of artworks whose type is not 'Program Talent Show'.
assistant
SELECT Name FROM artwork WHERE TYPE != 'Program Talent Show'
human
List the name of artworks that are not nominated.
assistant
SELECT Name FROM Artwork WHERE Artwork_ID NOT IN (SELECT Artwork_ID FROM nomination)
human
List the name of artworks in ascending alphabetical order.
assistant
SELECT Name FROM artwork ORDER BY Name ASC
human
How many artworks are there?
assistant
SELECT count(*) FROM artwork
human
Please show different types of artworks with the corresponding number of artworks of each type.
assistant
SELECT TYPE , COUNT(*) FROM artwork GROUP BY TYPE
human
List the most common type of artworks.
assistant
SELECT TYPE FROM artwork GROUP BY TYPE ORDER BY COUNT( * ) DESC LIMIT 1 ;