[LeetCode] 1341. Movie Rating

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH Rating AS (
    SELECT m.*
        , u.*
        , mr.rating
        , mr.created_at
    FROM MovieRating AS mr
        LEFT JOIN Movies AS m ON mr.movie_id = m.movie_id
        LEFT JOIN Users AS u ON mr.user_id = u.user_id
)

(SELECT name AS results
FROM Rating
GROUP BY user_id
ORDER BY COUNT(*) DESC, name ASC
LIMIT 1)

UNION ALL

(SELECT title AS results
FROM Rating
WHERE created_at >= '2020-02-01'
  AND created_at < '2020-03-01'
GROUP BY movie_id
ORDER BY AVG(rating) DESC, title ASC
LIMIT 1)