Show me the names of the artworks.
select name from artwork
Can you also tell me the types of these artworks?
select name, type from artwork
Which of these artworks were nominated in some festival?
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
What were the names of these festivals?
select t2.name, t3.festival_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