题解 | 查询每天刷题通过数最多的前二名用户id和刷题数

select
    date,
    user_id,
    pass_count
from
    (
        select
            date,
            user_id,
            pass_count,
            rank() over (
                partition by
                    date
                order by
                    pass_count desc
            ) 排序
        from
            test.questions_pass_record
    ) a
where
    排序 <= 2
order by
    date asc