题解 | #每天的日活数及新用户占比#
每天的日活数及新用户占比
https://www.nowcoder.com/practice/dbbc9b03794a48f6b34f1131b1a903eb
select
dt,
count(uid) as dau,
round(avg(newd=dt),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
) as t1
join (select uid,min(date(in_time)) as newd from tb_user_log group by uid ) as t2 using(uid)
group by dt
order by dt
avg(newd=dt) 等同于avg(if(newd=dt,1,0))
京东工作强度 418人发布