《学习MySQL语句》——第十九天

 用Union联合两个查询

# Write your MySQL query statement below

# 评论电影数量最多且字典序较小的用户名
(
    select Users.name as results
    FROM MovieRating
        JOIN Users ON MovieRating.user_id = Users.user_id
    GROUP BY MovieRating.user_id
    ORDER BY
        count(MovieRating.user_id) desc,
        Users.name
    LIMIT 1
)
UNION (
# 2020年2月份平均评分最高且字典序较小的电影名
    select
        Movies.title as results
    FROM MovieRating
        JOIN Movies ON MovieRating.movie_id = Movies.movie_id
    WHERE
        MovieRating.created_at >= '2020-02-01'
        AND MovieRating.created_at < '2020-03-01'
    GROUP BY MovieRating.movie_id
    ORDER BY
        avg(MovieRating.rating) desc,
        Movies.title
    LIMIT 1
)