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
Hello, can you please tell me the most weeks spent on top?
assistant
SELECT MAX( Weeks_on_Top ) FROM volume;
human
And how many volumes spent 3.0 weeks on top?
assistant
SELECT COUNT( * ) FROM volume WHERE weeks_on_top = 3.0 ;