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)
CREATE TABLE artwork (Artwork_ID NUMBER, Type CLOB, Name CLOB)

Show the total number from each type, and I want to sort in descending by the y-axis.
SELECT Type, COUNT(*) FROM artwork GROUP BY Type ORDER BY COUNT(*) DESC
SELECT "Type", COUNT(*) FROM "artwork" GROUP BY "Type" ORDER BY COUNT(*) DESC