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

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