CREATE TABLE artwork (Artwork_ID NUMBER, Type CLOB, Name CLOB)
CREATE TABLE festival_detail (Festival_ID NUMBER, Festival_Name CLOB, Chair_Name CLOB, Location CLOB, Year NUMBER, Num_of_Audience NUMBER)
CREATE TABLE nomination (Artwork_ID NUMBER, Festival_ID NUMBER, Result CLOB)

, rank in desc by the the total number .
SELECT Type, COUNT(*) FROM artwork GROUP BY Type ORDER BY COUNT(*) DESC
SELECT "Type", COUNT(*) FROM "artwork" GROUP BY "Type" ORDER BY COUNT(*) DESC