题解 | #每天的日活数及新用户占比#
每天的日活数及新用户占比
http://www.nowcoder.com/practice/dbbc9b03794a48f6b34f1131b1a903eb
select dt,count(distinct t1.uid)as dau,
round(count(t2.uid)/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)t1
left join
(select uid,min(date(in_time))as f_d
from tb_user_log
group by uid)t2 on t1.uid=t2.uid and t1.dt=t2.f_d
group by dt
order by dt
round(count(t2.uid)/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)t1
left join
(select uid,min(date(in_time))as f_d
from tb_user_log
group by uid)t2 on t1.uid=t2.uid and t1.dt=t2.f_d
group by dt
order by dt
查看6道真题和解析
可能从看你有勇气拒唯一的海康开始，我就被你折服了
这真的是最好的结局！
投递华为等公司10个岗位 >