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_votes_comparison
Usage
powerpipe query imdb.query.imdb_movie_votes_comparison
SQL
select 'Under 18' as "Age Group", CVotesU18M as "Male", CVotesU18F as "Female"from imdbwhere movie_id = $1unionselect '18-29' as "Age Group", CVotes1829M as "Male", CVotes1829F as "Female"from imdbwhere movie_id = $1unionselect '30-44' as "Age Group", CVotes3044M as "Male", CVotes3044F as "Female"from imdbwhere movie_id = $1unionselect '45+' as "Age Group", CVotes45AM as "Male", CVotes45AF as "Female"from imdbwhere movie_id = $1;
Dashboards
The query is used in the dashboards: