题解 | #注册当天就完成了试卷的名单第三页#

select 
a.uid,
b.level,
b.register_time,
max(a.score)
from exam_record a
left join user_info b on a.uid=b.uid
left join examination_info c on a.exam_id=c.exam_id 
where b.job='算法' and c.tag='算法' and timestampdiff(DAY,b.register_time,a.start_time)=0
and a.score is not null
group by a.uid,b.level,b.register_time
order by max(a.score) desc 
limit 6,3;