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

select t1.uid,level,register_time ,max(score) as max_score
from exam_record t join  examination_info using(exam_id)
    join user_info t1 on t.uid=t1.uid and date(t.submit_time) =date(t1.register_time)
    where job = '算法' and tag='算法'
group by t1.uid,level,register_time 
order by max_score desc 
limit 6,3