Show me the ids of the festivals.
select festival_id from festival_detail
Show me the names as well.
select festival_id, festival_name from festival_detail
Add in the artworks nominated as well.
select t3.festival_id, 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
Instead of showing the artworks nominated, show me the number of nominated artworks for each of these festivals.
select t1.festival_id, t3.festival_name, count(*) 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