题解 | #注册当天就完成了试卷的名单第三页#
注册当天就完成了试卷的名单第三页
https://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
select ui.uid, ui.level, ui.register_time, er.score
from user_info ui
inner join exam_record er on ui.uid = er.uid and date(ui.register_time) = date(er.submit_time)
inner join examination_info ei on er.exam_id = ei.exam_id and ei.tag = '算法'
where ui.job = '算法'
order by er.score desc
limit 6,3;
