Can you list the names of the festivals that had two or more nominations for artwork?
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 group by t1.festival_id having count ( * ) > = 2
Can you list their IDs in the table too?
select t3.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
What are the names of all the artworks that won?
select t2.name from nomination as t1 join artwork as t2 on t1.artwork_id = t2.artwork_id where t1.result = "Won"