Which vocal type did the musician with first name "Solveig" played in the song with title "A Bar in Amsterdam"?
create table vocals (songid varchar, bandmate varchar, PRIMARY KEY (songid)); create table band (id varchar, firstname varchar, PRIMARY KEY (id)); create table songs (songid varchar, title varchar, PRIMARY KEY (songid))
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"