题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select
user_id user_id
,max(rk) days_count
from
(
select
user_id
,sales_date
,dense_rank()over(partition by user_id order by sales_date) rk
from sales_tb
) t0
where rk>=2
group by user_id
order by user_id
