文章目录
题目
代码(7.24 首刷自解)
union all
可以保留重复的行
# Write your MySQL query statement below
(select u.name results from Users u inner join MovieRating m on u.user_id=m.user_id
group by u.user_id order by count(1) desc, u.name limit 1)
union all
(select title results from Movies m inner join MovieRating mr on m.movie_id = mr.movie_id
where created_at >= '2020-02-01' and created_at < '2020-03-01'
group by m.movie_id order by avg(rating) desc, title limit 1);