What is the maximum weeks on top in the table?
select weeks_on_top from volume order by weeks_on_top desc limit 1
Which volume id has the maximum weeks on top?
select distinct ( volume_id ) from volume where weeks_on_top = ( select weeks_on_top from volume order by weeks_on_top desc limit 1 )
Hmm, I want to know what is the song in the volume with the maximum weeks on top please.
select distinct ( song ) from volume where weeks_on_top = ( select weeks_on_top from volume order by weeks_on_top desc limit 1 )