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
What are the issue dates of volumes associated with the artist 'Gorgoroth'?
assistant
SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID = T2.Artist_ID WHERE T1.Artist = 'Gorgoroth'
human
What is the most common result of the music festival?
assistant
SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
human
What are the date of ceremony of music festivals with category 'Best Song' and result 'Awarded'?
assistant
SELECT Date_of_ceremony FROM music_festival WHERE Category = 'Best Song' AND RESULT = 'Awarded'
human
What are the famous title of the artists associated with volumes with more than 2 weeks on top?
assistant
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
human
What is the famous release date of the artist with the oldest age?
assistant
SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1
human
What are the distinct Famous release dates?
assistant
SELECT distinct ( Famous_Release_date ) FROM artist ;