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
Show me the names of all the artworks.
assistant
SELECT name FROM artwork;
human
Show me their types as well.
assistant
SELECT name , type FROM artwork;
human
What is the number of artworks for each type?
assistant
SELECT type , COUNT( * ) FROM artwork GROUP BY type;
human
Which of these types is the most common?
assistant
SELECT TYPE FROM artwork GROUP BY TYPE ORDER BY COUNT( * ) DESC LIMIT 1 ;