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
Please list the age and famous title of artists in descending order of age.
assistant
SELECT Famous_Title , Age FROM artist ORDER BY Age DESC
human
How many distinct artists do the volumes associate to?
assistant
SELECT COUNT(DISTINCT Artist_ID) FROM volume
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
List the age of all music artists.
assistant
SELECT Age FROM artist
human
What are the issue dates of volumes associated with the artist aged 23 or younger?
assistant
SELECT Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID = T2.Artist_ID WHERE T1.age <= 23
human
What are the songs in volumes associated with the artist aged 32 or older?
assistant
SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID = T2.Artist_ID WHERE T1.age >= 32 ;