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

SELECT
    uid,
    level,
    register_time,
    MAX(score) OVER(PARTITION BY uid) AS max_score
FROM 
    user_info JOIN exam_record USING(uid)
    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')
ORDER BY max_score DESC
LIMIT 6, 3