题解 | #注册当天就完成了试卷的名单第三页#

select
    uid,
    level,
    register_time,
    max(score) as max_score
from
    (
        select
            t1.uid as uid,
            t1.level as level,
            t1.register_time as register_time,
            t3.release_time as release_time,
            t2.score as score
        from
            user_info as t1
            inner join exam_record as t2 on t1.uid = t2.uid
            inner join examination_info as t3 on t2.exam_id = t3.exam_id
        where
            t3.tag = '算法'
            and t1.job = '算法'
            and t2.score is not null
    ) as tp
where
    day (tp.register_time) = day (tp.register_time)
group by
    tp.uid,
    tp.level,
    tp.register_time
order by max_score desc
limit 3 offset 6;