List the names of the festivals.
select festival_name from festival_detail
Show me the names of the nominated artworks for the festivals listed.
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
Which of these festivals have at least two nominations for artworks?
select 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 group by t3.festival_id having count(*) >= 2
Show me their ids as well.
select t1.festival_id, 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 group by t1.festival_id having count(*) >= 2