题解 | 筛选限定昵称成就值活跃日期的用户
筛选限定昵称成就值活跃日期的用户
https://www.nowcoder.com/practice/2ed07ff8f67a474d90523b88402e401b
select
distinct
er.uid,
ui.nick_name,
ui.achievement
from
exam_record er
left join
practice_record pr on er.uid = pr.uid
left join
user_info ui on er.uid = ui.uid
where
ui.nick_name like "牛客%号" and ui.achievement between 1200 and 2500
and (date_format(er.start_time,'%Y-%m') = '2021-09' or date_format(pr.submit_time,'%Y-%m') = '2021-09')
查看11道真题和解析