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

with
t1 as (
    select
        uid,
        nick_name,
        achievement
    from
        user_info
        inner join
        exam_record using(uid)
    where
        achievement between 1200 and 2500
        and
        date_format(exam_record.submit_time,'%Y%m')='202109'
        and
        nick_name like'牛客%号'
    group by
        uid
),
t2 as (
    select
        uid,
        nick_name,
        achievement
    from
        user_info
        inner join
        practice_record using(uid)
    where
        achievement between 1200 and 2500
        and
        date_format(practice_record.submit_time,'%Y%m')='202109'
        and
        nick_name like'牛客%号'
    group by
        uid
)
select * from t1
union
select * from t2