with t1 as( select uid,date(in_time)as dt,date(max(out_time)over()) as ct from tb_user_log union select uid,date(out_time) as dt ,date(max(out_time)over()) as ct from tb_user_log order by uid ,dt), t2 as( select uid,dt,ct, TIMESTAMPDIFF(day,dt,ct) as day1 from t1), t3 as( select uid,case when min(da...