CREATE TABLE Songs (Title VARCHAR2, SongId VARCHAR2)
CREATE TABLE Performance (bandmate VARCHAR2, SongId VARCHAR2)
CREATE TABLE Band (id VARCHAR2, firstname VARCHAR2)

Find all the songs produced by artists with first name 'Marianne'.
SELECT T3.Title FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate = T2.id JOIN Songs AS T3 ON T3.SongId = T1.SongId WHERE T2.firstname = "Marianne"
SELECT "T3"."Title" FROM "Performance" "T1" JOIN "Band" "T2" ON "Marianne" = "T2"."firstname" AND "T1"."bandmate" = "T2"."id" JOIN "Songs" "T3" ON "T1"."SongId" = "T3"."SongId"