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

select uid,
level,
register_time,
max(score) over(partition by uid ) as max_score
FROM user_info
inner join exam_record  using(uid)
inner join examination_info using(exam_id)
WHERE job='算法' AND tag='算法' 
AND date_format(submit_time,"%Y%m%d") = date_format(register_time,"%Y%m%d")
ORDER BY max_score DESC
limit 6,3;