WITH a AS (SELECT er.uid, `level`,start_time,submit_time,score,tag,job,register_time, RANK () OVER (PARTITION BY uid ORDER BY score DESC) rk FROM exam_record er JOIN user_info ui ON er.uid= ui.uid JOIN examination_info ei ON ei.exam_id = er.exam_id) SELECT uid, `level`, register_time,score FROM a WHERE uid IN (SELECT uid FROM a WHERE DATE_FORMAT(register_time,'%Y%m') = DATE_FORMAT(submit_time,'%Y%m') AND job = '算法' AND tag = '算法') AND rk=1 ORDER BY score DESC LIMIT 6,3