select t1.uid,level,register_time,max(score) as max_score from user_info t1 join exam_record t2 on t1.uid = t2.uid join examination_info t3 on t2.exam_id = t3.exam_id where t1.uid in ( select t1.uid from user_info t1 join exam_record t2 on t1.uid = t2.uid where date_format(t1.register_time,'%Y%m%d') = date_format(t2.submit_time,'%Y%m%d') and job = '算法' and tag = '算法' ) group by t1.uid,level,register_time order by max_score desc limit 6,3