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

select ui.uid,ui.level,ui.register_time, max(er.score)over(partition by ui.uid) max_score
from
user_info ui join exam_record er using(uid)
join examination_info ei using(exam_id)
where ui.job = "算法" and ei.tag="算法" and date_format(ui.register_time,"%Y%m%d")=date_format(er.submit_time,"%Y%m%d")
order by max_score desc
limit 6,3