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