1341. 电影评分

1341. 电影评分

题目链接：1341. 电影评分

代码如下：

# Write your MySQL query statement below
select t.results  
from(
    select u.name as results,mr.user_id
    from Users as u,MovieRating as mr
    where u.user_id=mr.user_id
    group by mr.user_id,u.name
    order by count(1) desc,u.name asc
    limit 1
) as t
union all
select q.results  
from(
    select m.title as results,mr.user_id
    from Movies as m,MovieRating as mr
    where m.movie_id=mr.movie_id
    and mr.created_at like '2020-02%'
    group by m.title
    order by avg(mr.rating) desc,m.title asc
    limit 1
) as q