题解 | 某宝店铺连续2天及以上购物的用户及其对应的天数

with t1 as
(select distinct sales_date, user_id,
SUBDATE(sales_date, INTERVAL dense_rank() over(partition by user_id order by sales_date) DAY) as tmp_date
from sales_tb),
t2 as
(select user_id,
count(tmp_date) as tmp_days_count
from t1
group by user_id, tmp_date)
select user_id,
max(tmp_days_count) as days_count
from t2 
where tmp_days_count>=2
group by user_id
order by user_id asc