题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id, count(user_id) as days_count from ( select distinct user_id, sales_date, dense_rank() over(partition by user_id order by sales_date) as ranks from sales_tb ) a group by user_id, date_sub(sales_date, interval ranks day) having count(user_id) >= 2 order by user_id asc
查看1道真题和解析