题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id,max(rnk)as days_count from( select user_id,dense_rank() OVER (PARTITION BY user_id ORDER BY sales_date) AS rnk,sales_date from sales_tb )a group by user_id having max(rnk)>=2
