题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
https://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select
t2.user_id,
count(distinct t2.sales_date)+1 as days_count
from sales_tb as t1,sales_tb as t2
where t1.user_id = t2.user_id and datediff(t1.sales_date,t2.sales_date) = 1
group by t2.user_id
order by t2.user_id
OPPO公司福利 1202人发布
