Leetcode Problem 1341. Movie Rating

1341. Movie Rating

Leetcode Solutions

Group By and Order By with Limit

Join the MovieRating and Users tables on user_id and group the result by user_id.
Count the number of ratings for each user and order the result by the count in descending order and by user name in ascending order.
Select the top result using LIMIT 1 to get the user with the most ratings.
Join the MovieRating and Movies tables on movie_id and filter the ratings to only include those from February 2020.
Group the result by movie_id and calculate the average rating for each movie.
Order the result by the average rating in descending order and by movie title in ascending order.
Select the top result using LIMIT 1 to get the movie with the highest average rating.
Combine the two results using UNION ALL.


erDiagram
    Movies {
        int movie_id PK
        varchar title
    }
    Users {
        int user_id PK
        varchar name
    }
    MovieRating {
        int movie_id PK
        int user_id PK
        int rating
        date created_at
    }

Using Window Functions for Ranking

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1341. Movie Rating

Leetcode Solutions

Group By and Order By with Limit

Solution Idea

Query Steps

Code Implementation

Using Window Functions for Ranking

Ask Question

Suggested Answer