Query: imdb_movie_by_rating_range

select
  case
    when Rating >= 9 then '9+'
    when Rating >= 8 then '8-8.9'
    when Rating >= 7 then '7-7.9'
    when Rating >= 6 then '6-6.9'
    else 'Below 6'
  end as "Rating Range",
    count(*) as "Number of Movies"
from
  IMDb
group by
  "Rating Range"
order by
  "Rating Range" desc;