select date, round(coalesce(count(distinct(if(datediff(last_date,date)=1 and is_new=1,user_id,null)))/ count(distinct(if(is_new=1,user_id,null))),0),3) as p from ( select user_id, date, if(date=min(date) over(partition by user_id),1,0) as is_new, lead(date) over(par...