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)

Please show different types of artworks with the corresponding number of artworks of each type.
SELECT type, COUNT(*) FROM artwork GROUP BY type
SELECT "type", COUNT(*) FROM "artwork" GROUP BY "type"