List the names of all the artworks.
select name from artwork
At which festivals were these artworks nominated?
select t1.name, t3.festival_name from artwork as t1 join nomination as t2 on t1.artwork_id = t2.artwork_id join festival_detail as t3 on t2.festival_id = t3.festival_id
What year were these artworks nominated?
select t1.name, t3.year from artwork as t1 join nomination as t2 on t1.artwork_id = t2.artwork_id join festival_detail as t3 on t2.festival_id = t3.festival_id
Can you list them in ascending order?
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