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") ...