select dt, count(distinct t1.uid) as dau, round(sum(if(t1.dt=t2.new_date,1,0))/count(distinct t1.uid),2) as uv_new_ratio from( select uid,date(in_time) as dt from tb_user_log union select uid,date(out_time) as dt from tb_user_log order by dt asc )t1 left join ( select u...