题解 | 注册当天就完成了试卷的名单第三页
注册当天就完成了试卷的名单第三页
https://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
SELECT ui.uid, ui.`level`, ui.register_time, max(er.score) over(PARTITION BY ui.uid) as max_score FROM exam_record er INNER JOIN user_info ui on er.uid = ui.uid and er.submit_time is not null and ui.job='算法' and DATE_FORMAT(submit_time,'%Y%m%d') = DATE_FORMAT(ui.register_time,'%Y%m%d') INNER JOIN examination_info ei on ei.exam_id = er.exam_id and ei.tag='算法' ORDER BY max_score desc LIMIT 3 offset 6;
