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)

List the most common type of artworks.
SELECT type FROM artwork GROUP BY type ORDER BY COUNT(*) DESC LIMIT 1
SELECT "type" FROM "artwork" GROUP BY "type" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY