题解 | #筛选限定昵称成就值活跃日期的用户#
筛选限定昵称成就值活跃日期的用户
https://www.nowcoder.com/practice/2ed07ff8f67a474d90523b88402e401b
纵享丝滑~
select user_info.uid,nick_name,achievement from user_info
join
(select uid from
(select uid,submit_time from exam_record
union all
select uid,submit_time from practice_record) t1
group by uid
having date_format(max(submit_time),'%Y%m') =202109) t2
on user_info.uid = t2.uid
where nick_name like '牛客%号' and achievement between 1200 and 2500
join
(select uid from
(select uid,submit_time from exam_record
union all
select uid,submit_time from practice_record) t1
group by uid
having date_format(max(submit_time),'%Y%m') =202109) t2
on user_info.uid = t2.uid
where nick_name like '牛客%号' and achievement between 1200 and 2500