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
The song The way was issued on what date?
assistant
SELECT Issue_Date FROM volume WHERE Song LIKE '%The Way%';
human
the song The way was issued what volume?
assistant
SELECT volume_Issue FROM volume WHERE Song LIKE '%The Way%';
human
what's the artist id for Everybody Have Fun Tonight
assistant
SELECT artist_id FROM volume WHERE Song LIKE '%Everybody Have Fun Tonight%';
human
Give me the issue date of the volume with the minimum weeks on top
assistant
SELECT Issue_Date FROM volume ORDER BY Weeks_on_Top ASC LIMIT 1 ;