明确题意:统计每天的日活数及新用户占比问题分解:查询活跃用户表:select uid,date(in_time) dt from tb_user_log union select uid,date(out_time) dt from tb_user_log计算用户注册时间:min(dt) over(partition by uid)按天分组:group by dt计算日活数:count(distinct uid)计算日活中新用户数:sum(if(register_dt = dt, 1, 0))计算新用户占比:new_cnt / dau细节问题:新用户占比保留2位小数:round(x,2)结果按...