题解 | #筛选限定昵称成就值活跃日期的用户#
筛选限定昵称成就值活跃日期的用户
https://www.nowcoder.com/practice/2ed07ff8f67a474d90523b88402e401b
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'
)
看了一圈，发现没有一样的，我这个是对的吗？
网易游戏公司福利 601人发布
，实习薪资开高一点也行吧