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