题解 | #每天的日活数及新用户占比#
每天的日活数及新用户占比
http://www.nowcoder.com/practice/dbbc9b03794a48f6b34f1131b1a903eb
SELECT dt,count(uid) dau,round(sum(if(((uid,dt) in (select uid,date(min(in_time)) from tb_user_log group by uid)),1,0))/count(uid),2) uv_new_ratio from( select uid,date(in_time) dt from tb_user_log union select uid,date(out_time) dt from tb_user_log ) a group by dt order by dt
