
CREATE TABLE "Albums" (
	"AId" INTEGER, 
	"Title" TEXT, 
	"Year" INTEGER, 
	"Label" TEXT, 
	"Type" TEXT, 
	PRIMARY KEY ("AId")
)


CREATE TABLE "Band" (
	"Id" INTEGER, 
	"Firstname" TEXT, 
	"Lastname" TEXT, 
	PRIMARY KEY ("Id")
)


CREATE TABLE "Instruments" (
	"SongId" INTEGER, 
	"BandmateId" INTEGER, 
	"Instrument" TEXT, 
	PRIMARY KEY ("SongId", "BandmateId", "Instrument"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("BandmateId") REFERENCES "Band" ("Id")
)


CREATE TABLE "Performance" (
	"SongId" INTEGER, 
	"Bandmate" INTEGER, 
	"StagePosition" TEXT, 
	PRIMARY KEY ("SongId", "Bandmate"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("Bandmate") REFERENCES "Band" ("Id")
)


CREATE TABLE "Songs" (
	"SongId" INTEGER, 
	"Title" TEXT, 
	PRIMARY KEY ("SongId")
)


CREATE TABLE "Tracklists" (
	"AlbumId" INTEGER, 
	"Position" INTEGER, 
	"SongId" INTEGER, 
	PRIMARY KEY ("AlbumId", "Position"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("AlbumId") REFERENCES "Albums" ("AId")
)


CREATE TABLE "Vocals" (
	"SongId" INTEGER, 
	"Bandmate" INTEGER, 
	"Type" TEXT, 
	PRIMARY KEY ("SongId", "Bandmate"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("Bandmate") REFERENCES "Band" ("Id")
)

CREATE TABLE "Albums" (
	"AId" INTEGER, 
	"Title" TEXT, 
	"Year" INTEGER, 
	"Label" TEXT, 
	"Type" TEXT, 
	PRIMARY KEY ("AId")
)

/*
2 rows from Albums table:
AId	Title	Year	Label	Type

*/


CREATE TABLE "Band" (
	"Id" INTEGER, 
	"Firstname" TEXT, 
	"Lastname" TEXT, 
	PRIMARY KEY ("Id")
)

/*
2 rows from Band table:
Id	Firstname	Lastname

*/


CREATE TABLE "Instruments" (
	"SongId" INTEGER, 
	"BandmateId" INTEGER, 
	"Instrument" TEXT, 
	PRIMARY KEY ("SongId", "BandmateId", "Instrument"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("BandmateId") REFERENCES "Band" ("Id")
)

/*
2 rows from Instruments table:
SongId	BandmateId	Instrument

*/


CREATE TABLE "Performance" (
	"SongId" INTEGER, 
	"Bandmate" INTEGER, 
	"StagePosition" TEXT, 
	PRIMARY KEY ("SongId", "Bandmate"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("Bandmate") REFERENCES "Band" ("Id")
)

/*
2 rows from Performance table:
SongId	Bandmate	StagePosition

*/


CREATE TABLE "Songs" (
	"SongId" INTEGER, 
	"Title" TEXT, 
	PRIMARY KEY ("SongId")
)

/*
2 rows from Songs table:
SongId	Title

*/


CREATE TABLE "Tracklists" (
	"AlbumId" INTEGER, 
	"Position" INTEGER, 
	"SongId" INTEGER, 
	PRIMARY KEY ("AlbumId", "Position"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("AlbumId") REFERENCES "Albums" ("AId")
)

/*
2 rows from Tracklists table:
AlbumId	Position	SongId

*/


CREATE TABLE "Vocals" (
	"SongId" INTEGER, 
	"Bandmate" INTEGER, 
	"Type" TEXT, 
	PRIMARY KEY ("SongId", "Bandmate"), 
	FOREIGN KEY("SongId") REFERENCES "Songs" ("SongId"), 
	FOREIGN KEY("Bandmate") REFERENCES "Band" ("Id")
)

/*
2 rows from Vocals table:
SongId	Bandmate	Type

*/
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"
[{'Nenhum': 'Nenhum resultado encontrado'}]