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