CREATE TABLE nomination (Festival_ID VARCHAR, Artwork_ID VARCHAR)
CREATE TABLE artwork (Artwork_ID VARCHAR)
CREATE TABLE festival_detail (Festival_Name VARCHAR, Festival_ID VARCHAR)

Show the id, name of each festival and the number of artworks it has nominated.
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
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"