human
Schema:
artist (Artist_ID, Artist, Age, Famous_Title, Famous_Release_date)
volume (Volume_ID, Volume_Issue, Issue_Date, Weeks_on_Top, Song, Artist_ID)
music_festival (ID, Music_Festival, Date_of_ceremony, Category, Volume, Result)
Please answer with SQL.
assistant
Sure, I understand.
human
Order volumes by weeks on top in increasing order.
assistant
SELECT * FROM volume ORDER BY weeks_on_top;
human
Which volumes lasted no more than 2 weeks on top?
assistant
SELECT volume_ID FROM volume WHERE weeks_on_top <= 2;
human
Which ones lasted more than 2 weeks on top?
assistant
SELECT volume_ID FROM volume WHERE weeks_on_top > 2;
human
What are the ceremony dates for these volumes?
assistant
SELECT DISTINCT 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 ;