题目平均次日留存率,我的理解,不应该是把每一天的次日留存率求出来,然后再求一个平均值吗?with m as ( select t1.date, count(distinct t2.device_id)/count(distinct t1.device_id) rr1 from question_practice_detail t1 left join question_practice_detail t2 on t1.device_id = t2.device_id and t2.date = t1.date + interval "1" day group by t1.date ) select avg(rr1) from m
1

相关推荐

牛客网
牛客企业服务