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

select

    ui.uid uid,

    ui.level level,

    ui.register_time register_time,

    max(er.score) max_score

from

    user_info ui

    join exam_record er on ui.uid = er.uid

    join examination_info ei on ei.exam_id = er.exam_id

where

    ui.job = '算法'

    and ei.tag = '算法'

    and date_format (ui.register_time, 'yyyy-MM-dd') = date_format (er.submit_time, 'yyyy-MM-dd')

group by

    ui.uid

order by

    max_score desc

limit

    6, 3