补一个参考了评论区各位的，满足最近活跃日期在2021年9月的： select uid,nick_name,achievement from user_info where nick_name like "牛客%号" and achievement between 1200 and 2500 and uid in ( select uid from exam_record group by uid having date_format(max(start_time),'%Y%m') = 202109 union select uid from practice_record group by uid having date_format(max(submit_time),'%Y%m')=202109 );