with t1 as ( select distinct user_id, sales_date from sales_tb ), t2 as ( select *, row_number() over(partition by user_id order by sales_date) as rn from t1 ), t3 as ( select *, date_sub(sales_date, interval rn day) as temp from t2 ), t4 as ( select user_id, count(1) a...