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

# 在试卷作答和题目练习记录表 筛选满足最近一次作答在2021年9月
select uid,nick_name,achievement 
from user_info
where nick_name like "牛客%号" 
AND uid in (
    select uid from exam_record
    group by uid
    having MAX(DATE_FORMAT(start_time,"%Y-%m")) = '2021-09'
    union all
    select uid from practice_record
    group by uid
    having MAX(DATE_FORMAT(submit_time,"%Y-%m")) = '2021-09'
)
AND achievement between 1200 AND 2500