题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
with t1 as( select distinct user_id,sales_date from sales_tb order by user_id), t2 as( select *, rank()over(partition by user_id order by sales_date) as rn from t1), t3 as ( select user_id,date_sub(sales_date,INTERVAL rn day) as dt from t2) select user_id,count(*) as days_count from t3 group by user_id,dt having count(*) >=2