turbot/imdb

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
imdb
where
movie_id = $1
union
select
'18-29' as "Age Group",
CVotes1829M as "Male",
CVotes1829F as "Female"
from
imdb
where
movie_id = $1
union
select
'30-44' as "Age Group",
CVotes3044M as "Male",
CVotes3044F as "Female"
from
imdb
where
movie_id = $1
union
select
'45+' as "Age Group",
CVotes45AM as "Male",
CVotes45AF as "Female"
from
imdb
where
movie_id = $1;

Dashboards

The query is used in the dashboards: