CREATE TABLE festival_detail (festival_id NUMBER, festival_name CLOB, chair_name CLOB, location CLOB, year NUMBER, num_of_audience NUMBER)
CREATE TABLE artwork (artwork_id NUMBER, type CLOB, name CLOB)
CREATE TABLE nomination (artwork_id NUMBER, festival_id NUMBER, result CLOB)

Show the names of artworks in ascending order of the year they are nominated in.
SELECT T2.name FROM nomination AS T1 JOIN artwork AS T2 ON T1.artwork_id = T2.artwork_id JOIN festival_detail AS T3 ON T1.festival_id = T3.festival_id ORDER BY T3.year
SELECT "T2"."name" FROM "nomination" "T1" JOIN "artwork" "T2" ON "T1"."artwork_id" = "T2"."artwork_id" JOIN "festival_detail" "T3" ON "T1"."festival_id" = "T3"."festival_id" ORDER BY "T3"."year"