Tell me everything about all the artworks.
select * from artwork
List only the names of all these artworks.
select name from artwork
Which of these were nominated?
select t1.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
Which of those weren't?
select name from artwork where artwork_id not in (select artwork_id from nomination)