Excellent!  For each nomination can you show me the name of the artwork associated with it, and the name of the festival where it was 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
name of the artwork associated with a nomination refers to joining nomination table with artwork table on Artwork_ID; name of the festival where it was nominated refers to joining nomination table with festival_detail table on Festival_ID;