法2需要修改时间条件的位置： with t1 as( select uid, date(in_time) as dt from tb_user_log union select uid, date(out_time) as dt from tb_user_log), t2 as (select uid, dt, min(dt) over(partition by uid) as min_time, lead(dt, 1) over(partition by uid order by dt) as next_time from t1) select dt, round(sum(case when dt = min_time and datediff(next_time, dt) = 1 then 1 else 0 end) / sum(case when dt = min_time then 1 else 0 end), 2) as uv_left_rate from t2 where date_format(min_time, '%Y%m') = 202111 group by dt having uv_left_rate is not null order by dt