Database: music_4

CREATE TABLE "artist" (
    "Artist_ID" int,
    "Artist" text,
    "Age" int,
    "Famous_Title" text,
    "Famous_Release_date" text,
    PRIMARY KEY ("Artist_ID")
);
CREATE TABLE "volume" (
    "Volume_ID" int,
    "Volume_Issue" text,
    "Issue_Date" text,
    "Weeks_on_Top" real,
    "Song" text,
    "Artist_ID" int,
    PRIMARY KEY ("Volume_ID"),
    FOREIGN KEY (`Artist_ID`) REFERENCES `artist`(`Artist_ID`)
);
CREATE TABLE "music_festival" (
    "ID" int,
    "Music_Festival" text,
    "Date_of_ceremony" text,
    "Category" text,
    "Volume" int,
    "Result" text,
    PRIMARY KEY (`ID`),
    FOREIGN KEY (`Volume`) REFERENCES `volume`(`Volume_ID`)
);

Question: How many artists are there?
SQL: SELECT count(*) FROM artist

Question: Count the number of artists.
SQL: SELECT count(*) FROM artist

Question: List the age of all music artists.
SQL: SELECT Age FROM artist

Question: What are the ages of all music artists?
SQL: SELECT Age FROM artist

Question: What is the average age of all artists?
SQL: SELECT avg(Age) FROM artist

Question: Return the average age across all artists.
SQL: SELECT avg(Age) FROM artist

Question: What are the famous titles of the artist "Triumfall"?
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"

Question: Return the famous titles of the artist called "Triumfall".
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"

Question: What are the distinct Famous release dates?
SQL: SELECT distinct(Famous_Release_date) FROM artist

Question: Give the distinct famous release dates for all artists.
SQL: SELECT distinct(Famous_Release_date) FROM artist

Question: Return the dates of ceremony and the results of all music festivals
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival

Question: What are the dates of ceremony and results for each music festival?
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival

Question: What are the category of music festivals with result "Awarded"?
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"

Question: Return the categories of music festivals that have the result "Awarded".
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"

Question: What are the maximum and minimum week on top of all volumes?
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume

Question: Give the maximum and minimum weeks on top across all volumes.
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume

Question: What are the songs in volumes with more than 1 week on top?
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1

Question: Give the songs included in volumes that have more than 1 week on top.
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1

Question: Please list all songs in volumes in ascending alphabetical order.
SQL: SELECT Song FROM volume ORDER BY Song

Question: What are the the songs in volumes, listed in ascending order?
SQL: SELECT Song FROM volume ORDER BY Song

Question: How many distinct artists do the volumes associate to?
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume

Question: Count the number of distinct artists who have volumes.
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume

Question: Please show the date of ceremony of the volumes that last more than 2 weeks on top.
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2

Question: What are the dates of ceremony at music festivals corresponding to volumes that lasted more than 2 weeks on top?
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2

Question: Please show the songs that have result "nominated" at music festivals.
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"

Question: What are the songs in volumes that have resulted in a nomination at music festivals?
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"

Question: What are the issue dates of volumes associated with the artist "Gorgoroth"?
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"

Question: Return the issue dates of volumes that are by the artist named Gorgoroth.
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"

Question: What are the songs in volumes associated with the artist aged 32 or older?
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32

Question: Return names of songs in volumes that are by artists that are at least 32 years old.
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32

Question: What is the average weeks on top of volumes associated with the artist aged 25 or younger?
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25

Question: Return the average number of weeks on top for volumes by artists that are at most 25 years old.
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25

Question: What are the famous title of the artists associated with volumes with more than 2 weeks on top?
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2

Question: Return the famous titles for artists that have volumes that lasted more than 2 weeks on top.
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2

Question: Please list the age and famous title of artists in descending order of age.
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC

Question: What are the famous titles and ages of each artist, listed in descending order by age?
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC

Question: What is the famous release date of the artist with the oldest age?
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1

Question: Return the famous release date for the oldest artist.
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1

Question: Please show the categories of the music festivals and the count.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category

Question: Return the number of music festivals of each category.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category

Question: What is the most common result of the music festival?
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1

Question: Return the result that is most frequent at music festivals.
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1

Question: Please show the categories of the music festivals with count more than 1.
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1

Question: What are the categories of music festivals for which there have been more than 1 music festival?
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1

Question: What is the song in the volume with the maximum weeks on top?
SQL: SELECT Song FROM volume ORDER BY Weeks_on_Top DESC LIMIT 1

Question: Return the song in the volume that has spent the most weeks on top?
SQL: SELECT Song FROM volume ORDER BY Weeks_on_Top DESC LIMIT 1

Question: Find the famous titles of artists that do not have any volume.
SQL: SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)

Question: What are the famous titles of artists who do not have any volumes?
SQL: SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)

Question: Show the famous titles of the artists with both volumes that lasted more than 2 weeks on top and volumes that lasted less than 2 weeks on top.
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2 INTERSECT SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  <  2

Question: What are the famous titles of artists who have not only had volumes that spent more than 2 weeks on top but also volumes that spent less than 2 weeks on top?
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2 INTERSECT SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  <  2

Question: What are the date of ceremony of music festivals with category "Best Song" and result "Awarded"?
SQL: SELECT Date_of_ceremony FROM music_festival WHERE Category  =  "Best Song" AND RESULT  =  "Awarded"

Question: Return the dates of ceremony corresponding to music festivals that had the category "Best Song" and result "Awarded".
SQL: SELECT Date_of_ceremony FROM music_festival WHERE Category  =  "Best Song" AND RESULT  =  "Awarded"

Question: What is the issue date of the volume with the minimum weeks on top?
SQL: SELECT Issue_Date FROM volume ORDER BY Weeks_on_Top ASC LIMIT 1

Question: Return the issue date of the volume that has spent the fewest weeks on top.
SQL: SELECT Issue_Date FROM volume ORDER BY Weeks_on_Top ASC LIMIT 1

Question: How many distinct artists have volumes?
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume

Question: Count the number of artists who have had volumes.
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume

Question: Please show the results of music festivals and the number of music festivals that have had each, ordered by this count.
SQL: SELECT RESULT ,  COUNT(*) FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC

Question: How many music festivals have had each kind of result, ordered descending by count?
SQL: SELECT RESULT ,  COUNT(*) FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC

Question: What are the issue dates of volumes associated with the artist aged 23 or younger?
SQL: SELECT Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  23

Question: Return the issue dates of volumes by artists who are at most 23 years old?
SQL: SELECT Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  23