题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id, count(distinct sales_date) from sales_tb where user_id in ( select user_id from sales_tb where (user_id, sales_date+1) in (select user_id, sales_date from sales_tb) ) group by user_id order by user_id
