Hello, can you please tell me the most weeks spent on top?
select max ( weeks_on_top ) from volume
And how many volumes spent 3.0 weeks on top?
select count ( * ) from volume where weeks_on_top = 3.0
I am sorry - what are the songs of the two volumes that spent 3.0 weeks on top?
select song from volume where weeks_on_top = 3.0
What was the minimum time spent on top?
select min ( weeks_on_top ) from volume
And how many volumes spent 1.0 weeks on top?
select count ( * ) from volume where weeks_on_top = 1.0
Yes please.
select artist_id from volume group by artist_id having count ( * ) > = 2