1341.sql

WITH UserRatingCount AS (
SELECTu.name, COUNT(mr.movie_id) AS rating_count
FROM Users u
JOIN MovieRating mr ONu.user_id=mr.user_id
GROUP BYu.name
ORDER BY rating_count DESC, u.name
LIMIT1
),
MovieAvgRating AS (
SELECTm.title, AVG(mr.rating) AS avg_rating
FROM Movies m
JOIN MovieRating mr ONm.movie_id=mr.movie_id
WHEREmr.created_at BETWEEN '2020-02-01'AND'2020-02-29'
GROUP BYm.title
ORDER BY avg_rating DESC, m.title
LIMIT1
)
SELECT name AS results FROM UserRatingCount
UNION ALL
SELECT title AS results FROM MovieAvgRating;