-- Database schema
| festival_detail : Festival_ID [ INT ] primary_key , Festival_Name [ TEXT ] , Chair_Name [ TEXT ] , Location [ TEXT ] , Year [ INT ] , Num_of_Audience [ INT ] | artwork : Artwork_ID [ INT ] primary_key , Type [ TEXT ] , Name [ TEXT ] | nomination : Artwork_ID [ INT ] primary_key nomination.Artwork_ID = artwork.Artwork_ID , Festival_ID [ INT ] nomination.Festival_ID = festival_detail.Festival_ID , Result [ TEXT ] |
-- -- For each nomination, show the name of the artwork and name of the festival where it is nominated.

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;