题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
某宝店铺连续2天及以上购物的用户及其对应的天数
http://www.nowcoder.com/practice/63ac3be0e4b44cce8dd2619d2236c3bf
select user_id,days_count
from
(
select user_id,sum(case when (user_id,sales_date) in (select user_id,date_add(sales_date,interval -1 day) from sales_tb ) then 1 else 0 end) as hege,count(sales_date) as days_count
from
(select sales_date,user_id
from sales_tb
group by sales_date,user_id) t
group by user_id
) m
where hege !=0
投递大华股份等公司6个岗位 >