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

select distinct uid,nick_name,achievement from exam_record left join user_info using(uid) where date_format(start_time,'%Y%m')='202109' and nick_name like '牛客%号' and achievement between 1200 and 2500 
union 
select distinct uid,nick_name,achievement from practice_record left join user_info using(uid) where date_format(submit_time,'%Y%m')='202109' and nick_name like '牛客%号' and achievement between 1200 and 2500