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

select
    ui .uid,nick_name,achievement
from
    user_info ui 
    left outer join exam_record er on  ui.uid = er.uid
    left outer join practice_record pr on ui.uid = pr.uid
where 
    nick_name like '牛客%号'
    and achievement between 1200 and 2500
group by
    ui .uid
having
    date_format(max(pr.submit_time),"%Y%m") = '202109'
    or date_format(max(start_time),"%Y%m") = '202109'