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_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_idorder by "Profit" desc;
Dashboards
The query is used in the dashboards: