What are the names of all the festivals?
select festival_name from festival_detail
What are the nominated artworks of these festivals?
select t3.festival_name, 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
Show the types of these artworks given these festivals.
select t3.festival_name, 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 festivals have type "Program Talent Show"?
select 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 where t2.type = "Program talent Show"