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

试卷或题目有一个最近在202109就可以，OR

SELECT
uid,
nick_name,
achievement
from 
(SELECT
ui.uid,
nick_name,
achievement,
pr.submit_time,
er.start_time
FROM user_info ui
LEFT JOIN exam_record er USING(uid)
LEFT JOIN practice_record pr USING(uid)
WHERE nick_name LIKE '牛客%号' AND (achievement BETWEEN 1200 AND 2500)) t
GROUP BY uid,nick_name,achievement
HAVING DATE_FORMAT(MAX(submit_time),'%Y%m') = '202109' OR DATE_FORMAT(MAX(start_time),'%Y%m') = '202109';