select t4.dt,num,round(if(num_new is null ,0,num_new)/num,2) uv_new_ratio from (select dt,count(dt) num_new from (select uid ,date(min(in_time)) dt from tb_user_log group by uid) t1 group by dt ) t3#新用户 right join (select dt,count(uid) num from ((select uid,date(in_time) dt from tb_user_log ) un...