题解 | 筛选限定昵称成就值活跃日期的用户

select
    distinct
        er.uid,
        ui.nick_name,
        ui.achievement
from
    exam_record er
left join
    practice_record pr on er.uid = pr.uid 
left join 
    user_info ui on er.uid = ui.uid
where 
    ui.nick_name like "牛客%号" and ui.achievement between 1200 and 2500
    and (date_format(er.start_time,'%Y-%m') = '2021-09' or date_format(pr.submit_time,'%Y-%m') = '2021-09')