select m.d1 user_id,count(distinct(m.s1)) days_count from ( SELECT user_id d1,sales_date s1,sales_date-dense_rank() over(partition by user_id order by sales_date asc) r1 FROM sales_tb ) m group by m.d1,m.r1 having days_count>=2