题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

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