题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id,sum(gap)+1 from (select user_id, timestampdiff(day,sales_date,nextday) as gap from (select user_id,sales_date, lead(sales_date,1,0) over(partition by user_id order by sales_date) as nextday from sales_tb group by user_id,sales_date order by user_id)c1)c2 where gap=1 group by user_id