turbot/imdb

Query: imdb_movie_distribution_of_metacritic_scores

Usage

powerpipe query imdb.query.imdb_movie_distribution_of_metacritic_scores

SQL

select
case
when Metacritic >= 90 then '90+'
when Metacritic >= 80 then '80-89'
when Metacritic >= 70 then '70-79'
when Metacritic >= 60 then '60-69'
else 'Below 60'
end as "Metacritic Range",
count(*) as "Number of Movies"
from
IMDb
group by
"Metacritic Range"
order by
"Number of Movies" desc;

Dashboards

The query is used in the dashboards: