imdb_movie_average_budgetimdb_movie_average_domestic_earningsimdb_movie_average_worldwide_earningsimdb_movie_by_rating_rangeimdb_movie_distribution_of_metacritic_scoresimdb_movie_domestic_vs_worldwide_earnings_comparisonimdb_movie_earning_domesticimdb_movie_earning_worldwideimdb_movie_genre_popularity_by_age_groupimdb_movie_inputimdb_movie_international_vs_us_votes_comparisonimdb_movie_overviewimdb_movie_profit_comparisonimdb_movie_ratingimdb_movie_runtimeimdb_movie_top_earning_worldwideimdb_movie_top_ratedimdb_movie_totalimdb_movie_votes_comparisonimdb_movie_votes_summaryimdb_moview_earnings_by_genre
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 IMDbgroup by "Metacritic Range"order by "Number of Movies" desc;
Dashboards
The query is used in the dashboards: