Tell me about the names of all the artworks.
select name from artwork
What are the types of all these artworks?
select distinct type from artwork
Which of these were nominated?
select distinct t1.type 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
Which of these were nominated in 2007?
select distinct t2.type 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 where t3.year = 2007