题解 | #注册当天就完成了试卷的名单第三页#
注册当天就完成了试卷的名单第三页
http://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
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