
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

*/
What is the type of vocables that appears most frequently?
SELECT TYPE FROM vocals GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1
[{'Nenhum': 'Nenhum resultado encontrado'}]