CREATE TABLE artwork (artwork_id NUMBER, type CLOB, name CLOB)
CREATE TABLE festival_detail (festival_id NUMBER, festival_name CLOB, chair_name CLOB, location CLOB, year NUMBER, num_of_audience NUMBER)
CREATE TABLE nomination (artwork_id NUMBER, festival_id NUMBER, result CLOB)

Show the ids and names of festivals that have at least two nominations for artworks.
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
SELECT "T1"."festival_id", "T3"."festival_name" FROM "nomination" "T1" JOIN "artwork" "T2" ON "T1"."artwork_id" = "T2"."artwork_id" JOIN "festival_detail" "T3" ON "T1"."festival_id" = "T3"."festival_id" GROUP BY "T1"."festival_id" HAVING COUNT(*) >= 2