题解 | 某宝店铺连续2天及以上购物的用户及其对应的天数
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id,count(1) days_count from ( select *,sales_date - rank()over(partition by user_id order by sales_date) num from( select distinct sales_date,user_id from sales_tb) as t1) as t2 group by user_id,num having days_count > 1 order by user_id
做多了凭肌肉记忆都会写了
查看19道真题和解析
