_1341.sql

--# Write your MySQL query statement below
SELECT user_name AS results FROM
(
SELECTa.nameAS user_name, COUNT(*) AS counts FROM Movie_Rating AS b
JOIN Users AS a
ona.user_id=b.user_id
GROUP BYb.user_id
ORDER BY counts DESC, user_name ASCLIMIT1
) first_query
UNION
SELECT movie_name AS results FROM
(
SELECTc.titleAS movie_name, AVG(d.rating) AS rate FROM Movie_Rating AS d
JOIN Movies AS c
onc.movie_id=d.movie_id
WHERE substr(d.created_at, 1, 7) ='2020-02'
GROUP BYd.movie_id
ORDER BY rate DESC, movie_name ASCLIMIT1
) second_query;