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

select
    uid,
    nick_name,
    achievement
from
    user_info
where
    nick_name like '牛客%号'
    and achievement between 1200 and 2500
    and uid in (
        select
            uid
        from
            exam_record
        group by
            uid
        having
            max(DATE_FORMAT (start_time, '%Y%m')) = 202109
        union
        select
            uid
        from
            practice_record
        group by
            uid
        having
            max(DATE_FORMAT (submit_time, '%Y%m')) = 202109
    )