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: How many bands are there?
SQL: SELECT count(*) FROM Band

Question: Find the number of bands.
SQL: SELECT count(*) FROM Band

Question: What are all the labels?
SQL: SELECT DISTINCT label FROM Albums

Question: What are the different album labels listed?
SQL: SELECT DISTINCT label FROM Albums

Question: Find all the albums in 2012.
SQL: SELECT * FROM Albums WHERE YEAR  =  2012

Question: return all columns of the albums created in the year of 2012.
SQL: SELECT * FROM Albums WHERE YEAR  =  2012

Question: Find all the stage positions of the musicians with first name "Solveig"
SQL: SELECT DISTINCT T1.stageposition FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id WHERE Firstname  =  "Solveig"

Question: What are the different stage positions for all musicians whose first name is "Solveig"?
SQL: SELECT DISTINCT T1.stageposition FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id WHERE Firstname  =  "Solveig"

Question: How many songs are there?
SQL: SELECT count(*) FROM Songs

Question: Count the number of songs.
SQL: SELECT count(*) FROM Songs

Question: Find all the songs performed by artist with last name "Heilo"
SQL: SELECT T3.Title FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T2.Lastname  =  "Heilo"

Question: What are the names of the songs by the artist whose last name is "Heilo"?
SQL: SELECT T3.Title FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T2.Lastname  =  "Heilo"

Question: Hom many musicians performed in the song "Flash"?
SQL: SELECT count(*) 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  =  "Flash"

Question: How many musicians play in the song "Flash"?
SQL: SELECT count(*) 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  =  "Flash"

Question: Find all the songs produced by artists with first name "Marianne".
SQL: SELECT T3.Title FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T2.firstname  =  "Marianne"

Question: What are the names of all songs produced by the artist with the first name "Marianne"?
SQL: SELECT T3.Title FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId WHERE T2.firstname  =  "Marianne"

Question: Who performed the song named "Badlands"? Show the first name and the 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  =  "Badlands"

Question: What are the first and last names of the artist who perfomed the song "Badlands"?
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  =  "Badlands"

Question: Who is performing in the back stage position for the song "Badlands"? Show the first name and the 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  =  "Badlands" AND T1.StagePosition  =  "back"

Question: What are the first and last names of the performer who was in the back stage position for the song "Badlands"?
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  =  "Badlands" AND T1.StagePosition  =  "back"

Question: How many unique labels are there for albums?
SQL: SELECT count(DISTINCT label) FROM albums

Question: What are the unique labels for the albums?
SQL: SELECT count(DISTINCT label) FROM albums

Question: What is the label that has the most albums?
SQL: SELECT label FROM albums GROUP BY label ORDER BY count(*) DESC LIMIT 1

Question: What is the label with the most albums?
SQL: SELECT label FROM albums GROUP BY label ORDER BY count(*) DESC LIMIT 1

Question: What is the last name of the musician that have produced the most number of songs?
SQL: SELECT T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId GROUP BY lastname ORDER BY count(*) DESC LIMIT 1

Question: What is the last name of the musician who was in the most songs?
SQL: SELECT T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId GROUP BY lastname ORDER BY count(*) DESC LIMIT 1

Question: What is the last name of the musician that has been at the back position the most?
SQL: SELECT T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id WHERE stageposition  =  "back" GROUP BY lastname ORDER BY count(*) DESC LIMIT 1

Question: What is the last name of the musicians who has played back position the most?
SQL: SELECT T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id WHERE stageposition  =  "back" GROUP BY lastname ORDER BY count(*) DESC LIMIT 1

Question: Find all the songs whose name contains the word "the".
SQL: SELECT title FROM songs WHERE title LIKE '% the %'

Question: What are the names of the songs whose title has the word "the"?
SQL: SELECT title FROM songs WHERE title LIKE '% the %'

Question: What are all the instruments used?
SQL: SELECT DISTINCT instrument FROM Instruments

Question: What are the different instruments listed in the database?
SQL: SELECT DISTINCT instrument FROM Instruments

Question: What instrument did the musician with last name "Heilo" use in the song "Le Pop"?
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  =  "Le Pop"

Question: What instruments did the musician with the last name "Heilo" play in the song "Le Pop"?
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  =  "Le Pop"

Question: What is the most used instrument?
SQL: SELECT instrument FROM instruments GROUP BY instrument ORDER BY count(*) DESC LIMIT 1

Question: What instrument is used the most?
SQL: SELECT instrument FROM instruments GROUP BY instrument ORDER BY count(*) DESC LIMIT 1

Question: How many songs have used the instrument "drums"?
SQL: SELECT count(*) FROM instruments WHERE instrument  =  "drums"