题解 | #小破站9月新会员人数#
小破站9月新会员人数
http://www.nowcoder.com/practice/aaa8bf0381cf4f6ca53665cea37e405e
select count(distinct(user_id))
from detail_list_tb
where begin_date between '2021-09-01' and '2021-09-30'
and user_id not in
(select user_id from detail_list_tb where begin_date<'2021-09-01');