题解 | #注册当天就完成了试卷的名单第三页#
注册当天就完成了试卷的名单第三页
http://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
select er.uid, level, register_time, max(score) over (partition by uid) as max_score
from examination_info ei, user_info ui, exam_record er
where ei.exam_id = er.exam_id and ui.uid = er.uid and job = "算法" and tag = "算法" and date(register_time) = date(submit_time)
order by max_score desc
limit 6, 3
顺丰集团工作强度 382人发布