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