IMDb Max Weighted Rating

Easy

0/40

Average time to solve is 10m

Problem statement

Print the genre and the maximum weighted rating among all the movies of that genre released in 2014 per genre. (Download the dataset from console)

Note:

1. Do not print any row where either genre or the weighted rating is empty/null.
2.  weighted_rating = avgerge of (rating + metacritic/10.0)
3. Keep the name of the columns as 'genre' and 'weighted_rating'
4. The genres should be printed in alphabetical order.

(100% EXP penalty)

IMDb Max Weighted Rating

Console