题解 | #每天的日活数及新用户占比#

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 )
union 
(select uid,date(out_time) dt
from tb_user_log)) t2
group by dt)  t4#用户活跃表
on t3.dt=t4.dt