select dt, count(distinct t1.uid) as dau, round(sum(if(t1.dt1 = t2.dt,1,0)) / count(distinct t1.uid),2) as uv_new_ratio from ( select uid, min(date(in_time)) as dt1 from tb_user_log group by uid ) t1 left join (select uid,date(in_time) as dt from tb_user_log union select uid, date(out_time) as dt fr...