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: 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