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 order names in asc order.
SELECT Type, COUNT(*) FROM artwork GROUP BY Type ORDER BY Type
SELECT "Type", COUNT(*) FROM "artwork" GROUP BY "Type" ORDER BY "Type"