题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
with t as ( select distinct user_id, sales_date from sales_tb ) select t1.user_id,count(*)+1 from t t1 left join t t2 on t1.user_id=t2.user_id and datediff(date(t2.sales_date),date(t1.sales_date))=1 where t2.user_id is not null group by t1.user_id order by t1.user_id