CREATE TABLE artwork (Name VARCHAR(255), Artwork_ID VARCHAR(255)); CREATE TABLE nomination (Artwork_ID VARCHAR(255), Festival_ID VARCHAR(255)); CREATE TABLE festival_detail (Festival_Name VARCHAR(255), Festival_ID VARCHAR(255))
For each nomination, show the name of the artwork and name of the festival where it is nominated.
    
SQL: SELECT T2.Name, 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