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

select uid,nick_name,achievement
from user_info
where (uid in(
select uid
from exam_record
where date_format(start_time,"%Y%m" ) = 202109)
or uid in(
    select uid 
    from practice_record
    where date_format(submit_time,"%Y%m" ) = 202109))
and nick_name like "牛客%号"
and achievement between 1200 and 2500

注意or和and的优先级