CREATE TABLE artist (
    Artist_ID NUMBER PRIMARY KEY,
    Artist TEXT,
    Age NUMBER,
    Famous_Title TEXT,
    Famous_Release_date TEXT
);
CREATE TABLE volume (
    Volume_ID NUMBER PRIMARY KEY,
    Volume_Issue TEXT,
    Issue_Date TEXT,
    Weeks_on_Top NUMBER,
    Song TEXT,
    Artist_ID NUMBER,
    FOREIGN KEY ("Artist_ID") REFERENCES artist("Artist_ID")
);
CREATE TABLE music_festival (
    ID NUMBER PRIMARY KEY,
    Music_Festival TEXT,
    Date_of_ceremony TEXT,
    Category TEXT,
    Volume NUMBER,
    Result TEXT,
    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)