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

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

看了一圈，发现没有一样的，我这个是对的吗？