CREATE TABLE Songs (
    SongId NUMBER PRIMARY KEY,
    Title TEXT
);
CREATE TABLE Albums (
    AId NUMBER PRIMARY KEY,
    Title TEXT,
    Year NUMBER,
    Label TEXT,
    Type TEXT
);
CREATE TABLE Band (
    Id NUMBER PRIMARY KEY,
    Firstname TEXT,
    Lastname TEXT
);
CREATE TABLE Instruments (
    SongId NUMBER PRIMARY KEY,
    BandmateId NUMBER,
    Instrument TEXT,
    FOREIGN KEY ("BandmateId") REFERENCES Band("Id"),
    FOREIGN KEY ("SongId") REFERENCES Songs("SongId")
);
CREATE TABLE Performance (
    SongId NUMBER PRIMARY KEY,
    Bandmate NUMBER,
    StagePosition TEXT,
    FOREIGN KEY ("Bandmate") REFERENCES Band("Id"),
    FOREIGN KEY ("SongId") REFERENCES Songs("SongId")
);
CREATE TABLE Tracklists (
    AlbumId NUMBER PRIMARY KEY,
    Position NUMBER,
    SongId NUMBER,
    FOREIGN KEY ("AlbumId") REFERENCES Albums("AId"),
    FOREIGN KEY ("SongId") REFERENCES Songs("SongId")
);
CREATE TABLE Vocals (
    SongId NUMBER PRIMARY KEY,
    Bandmate NUMBER,
    Type TEXT,
    FOREIGN KEY ("Bandmate") REFERENCES Band("Id"),
    FOREIGN KEY ("SongId") REFERENCES Songs("SongId")
);

Question: What instruments did the musician with the last name "Heilo" play in "Badlands"?
SQL: SELECT T4.instrument FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId JOIN Instruments AS T4 ON T4.songid  =  T3.songid AND T4.bandmateid  =  T2.id WHERE T2.lastname  =  "Heilo" AND T3.title  =  "Badlands"

Question: How many instruments does the song "Badlands" use?
SQL: SELECT count(DISTINCT instrument) FROM instruments AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Badlands"

Question: How many different instruments are used in the song "Badlands"?
SQL: SELECT count(DISTINCT instrument) FROM instruments AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Badlands"

Question: What are the vocal types used in song "Badlands"?
SQL: SELECT TYPE FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Badlands"

Question: What types of vocals are used in the song "Badlands"?
SQL: SELECT TYPE FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Badlands"

Question: Find the number of vocal types used in song "Le Pop"
SQL: SELECT count(*) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Le Pop"

Question: How many vocal types are used in the song "Le Pop"?
SQL: SELECT count(*) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE title  =  "Le Pop"

Question: How many songs have a shared vocal?
SQL: SELECT count(DISTINCT title) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE TYPE  =  "shared"

Question: How many different songs have shared vocals?
SQL: SELECT count(DISTINCT title) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid  =  T2.songid WHERE TYPE  =  "shared"

Question: Find all the songs that do not have a back vocal.
SQL: SELECT DISTINCT title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid EXCEPT SELECT t2.title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid WHERE TYPE  =  "back"

Question: What are the different names of all songs without back vocals?
SQL: SELECT DISTINCT title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid EXCEPT SELECT t2.title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid WHERE TYPE  =  "back"

Question: Which vocal type has the band mate with first name "Solveig" played the most?
SQL: SELECT TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate  =  T2.id WHERE firstname  =  "Solveig" GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1

Question: What are the types of vocals that the band member with the first name "Solveig" played the most?
SQL: SELECT TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate  =  T2.id WHERE firstname  =  "Solveig" GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1

Question: Which vocal type did the musician with last name "Heilo" played in the song with title "Der Kapitan"?
SQL: 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.lastname  =  "Heilo" AND T2.title  =  "Der Kapitan"

Question: What are the types of vocals that the musician with the last name "Heilo" played in "Der Kapitan"?
SQL: 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.lastname  =  "Heilo" AND T2.title  =  "Der Kapitan"

Question: Find the first name of the band mate that has performed in most songs.
SQL: SELECT t2.firstname FROM Performance AS t1 JOIN Band AS t2 ON t1.bandmate  =  t2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId GROUP BY firstname ORDER BY count(*) DESC LIMIT 1

Question: What is the first name of the band mate who perfomed in the most songs?
SQL: SELECT t2.firstname FROM Performance AS t1 JOIN Band AS t2 ON t1.bandmate  =  t2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId GROUP BY firstname ORDER BY count(*) DESC LIMIT 1

Question: Which vocal type has the band mate with first name "Marianne" played the most?
SQL: SELECT TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate  =  T2.id WHERE firstname  =  "Marianne" GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1

Question: What is the vocal type of the band mate whose first name is "Marianne" played the most?
SQL: SELECT TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate  =  T2.id WHERE firstname  =  "Marianne" GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1

Question: Who is performing in the back stage position for the song "Der Kapitan"? Show the first name and last name.
SQL: SELECT T2.firstname ,  T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T3.Title  =  "Der Kapitan" AND T1.StagePosition  =  "back"

Question: What is the first and last name of the artist who performed back stage for the song "Der Kapitan"?
SQL: SELECT T2.firstname ,  T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T3.Title  =  "Der Kapitan" AND T1.StagePosition  =  "back"

Question: Find the name of songs that does not have a back vocal.
SQL: SELECT DISTINCT title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid EXCEPT SELECT t2.title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid WHERE TYPE  =  "back"

Question: What are the names of the songs that do not have back vocals?
SQL: SELECT DISTINCT title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid EXCEPT SELECT t2.title FROM vocals AS t1 JOIN songs AS t2 ON t1.songid  =  t2.songid WHERE TYPE  =  "back"

Question: What are the songs in album "A Kiss Before You Go: Live in Hamburg"?
SQL: SELECT T3.title FROM albums AS T1 JOIN tracklists AS T2 ON T1.aid  =  T2.albumid JOIN songs AS T3 ON T2.songid  =  T3.songid WHERE T1.title  =  "A Kiss Before You Go: Live in Hamburg"

Question: What are the song titles on the album "A Kiss Before You Go: Live in Hamburg"?
SQL: SELECT T3.title FROM albums AS T1 JOIN tracklists AS T2 ON T1.aid  =  T2.albumid JOIN songs AS T3 ON T2.songid  =  T3.songid WHERE T1.title  =  "A Kiss Before You Go: Live in Hamburg"

Question: What are all the songs in albums under label "Universal Music Group"?
SQL: SELECT T3.title FROM albums AS T1 JOIN tracklists AS T2 ON T1.aid  =  T2.albumid JOIN songs AS T3 ON T2.songid  =  T3.songid WHERE t1.label  =  "Universal Music Group"

Question: What are the names of all the songs whose album is under the label of "Universal Music Group"?
SQL: SELECT T3.title FROM albums AS T1 JOIN tracklists AS T2 ON T1.aid  =  T2.albumid JOIN songs AS T3 ON T2.songid  =  T3.songid WHERE t1.label  =  "Universal Music Group"