with t1 as ( select user_id,date(log_time) log_time,row_number()over(partition by user_id order by date(log_time)) as rk from login_tb group by user_id,date(log_time) ) ,t2 as ( select *,date_sub(log_time,interval rk day) as t2 from t1 ) ,t3 as ( select user_id,t2,count(...