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

select uid,nick_name,achievement
from user_info
where uid in (
select uid from(
select uid,max(left(submit_time,7)) as max_date from(
select uid,submit_time
from exam_record
union all
select uid,submit_time
from practice_record)
as t1
where uid in (select uid
from user_info
where nick_name like '牛客%号'
and achievement between 1200 and 2500)
group by uid) as t2
where max_date = '2021-09')