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_scoresSQL
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: