CREATE TABLE Band (id VARCHAR2)
CREATE TABLE Performance (stageposition VARCHAR2, bandmate VARCHAR2)

Find all the stage positions of the musicians with first name 'Solveig
SELECT DISTINCT T1.stageposition FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate = T2.id WHERE Firstname = "Solveig"
SELECT DISTINCT "T1"."stageposition" FROM "Performance" "T1" JOIN "Band" "T2" ON "T1"."bandmate" = "T2"."id" WHERE "Firstname" = "Solveig"