sql39（Leetcode1341电影评分）

代码：

# Write your MySQL query statement below
select t3.name as results
from(
select t1.user_id,count(t1.movie_id) as counts,t2.name
from MovieRating t1
left join Users t2
on t1.user_id=t2.user_id
group by t1.user_id
order by counts desc,t2.name
limit 1) t3
union all
select t3.title as results
from 
(select t1.movie_id,avg(t1.rating) as avg_rate, t2.title
from MovieRating t1
left join Movies t2
on t1.movie_id=t2.movie_id
where created_at>='2020-02-01' and created_at<='2020-02-29'
group by movie_id
order by avg_rate desc,t2.title
limit 1) t3