题解 | 每天的日活数及新用户占比
每天的日活数及新用户占比
https://www.nowcoder.com/practice/dbbc9b03794a48f6b34f1131b1a903eb
select dt,count(*) as dau, round(sum(new_in = dt)/count(*),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)a join(select uid,min(date(in_time))as new_in from tb_user_log group by uid)b using (uid) group by dt order by dt
算逻辑表达式时不要习惯性用count
从0开始的SQL之旅 文章被收录于专栏
从0开始的SQL之旅
OPPO公司福利 570人发布
投递拼多多集团-PDD等公司10个岗位 >
