IMDb Genre

Hard

0/120

Average time to solve is 30m

Problem statement

Print the genre and the maximum net profit among all the movies of that genre released in 2012 per genre. (Download the dataset from console)

Note:

1. Do not print any row where either genre or the net profit is empty/null.
2. net_profit = Domestic + Worldwide - Budget
3. Keep the name of the columns as 'genre' and 'net_profit'
4. The genres should be printed in alphabetical order.

(100% EXP penalty)

IMDb Genre

Console