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

with cte_get_user as (
    select uid,level,register_time,min(submit_time) as first_submit,
    max(score) as max_score
    from user_info
    join exam_record using(uid)
    join examination_info using(exam_id)
    where job = '算法' and tag = '算法' and submit_time is not null
    group by uid
)
select uid,level,register_time,max_score
from cte_get_user
where date_format(register_time,'%Y%m%d')=date_format(first_submit,'%Y%m%d')
group by uid
order by max_score desc
limit 6,3