CREATE TABLE instruments (songid NUMBER, bandmateid NUMBER, instrument CLOB)
CREATE TABLE albums (aid NUMBER, title CLOB, year NUMBER, label CLOB, type CLOB)
CREATE TABLE tracklists (albumid NUMBER, position NUMBER, songid NUMBER)
CREATE TABLE performance (songid NUMBER, bandmate NUMBER, stageposition CLOB)
CREATE TABLE songs (songid NUMBER, title CLOB)
CREATE TABLE band (id NUMBER, firstname CLOB, lastname CLOB)
CREATE TABLE vocals (songid NUMBER, bandmate NUMBER, type CLOB)

Which vocal type did the musician with first name 'Solveig' played in the song with title 'A Bar in Amsterdam'?
SELECT type FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid JOIN band AS T3 ON T1.bandmate = T3.id WHERE T3.firstname = "Solveig" AND T2.title = "A Bar In Amsterdam"
SELECT "type" FROM "vocals" "T1" JOIN "songs" "T2" ON "A Bar In Amsterdam" = "T2"."title" AND "T1"."songid" = "T2"."songid" JOIN "band" "T3" ON "Solveig" = "T3"."firstname" AND "T1"."bandmate" = "T3"."id"