题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
with temp as( select user_id, sales_date, rank() over( partition by user_id order by sales_date asc ) as rk, num from ( select sales_date, user_id, num from ( select sales_date, user_id, sum(sales_num) as num from sales_tb group by sales_date, user_id ) t1 ) t ) select user_id, count(num) from ( select user_id, sales_date, sales_date - rk as tp, num from temp ) t2 group by user_id, tp having count(num) >1 order by user_id