turbot/imdb

Query: imdb_movie_profit_comparison

Usage

powerpipe query imdb.query.imdb_movie_profit_comparison

SQL

select
i.title as "Movie",
(e.worldwide - i.budget) as "Profit"
from
imdb as i
join earning as e on i.movie_id = e.movie_id
order by
"Profit" desc;

Dashboards

The query is used in the dashboards: