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

注意：在计算活跃用户时，试卷作答表和题目作答表都能作为活跃用户数，因此要满足条件。

SELECT distinct t2.uid,
t1.nick_name,
t1.achievement
from user_info t1
left join exam_record t2 on t1.uid=t2.uid
left join practice_record t3 on t1.uid=t3.uid
where t1.achievement BETWEEN 1200 and 2500
and (date(t2.submit_time)BETWEEN '2021-09-01' and '2021-09-30' or DATE(t3.submit_time) BETWEEN '2021-09-01' and '2021-09-30')
and t1.nick_name LIKE '牛客%' and t1.nick_name LIKE '%号';