Naruse

分类

/ 注册

全部文章（共11篇）

题解 | 计算用户的平均次日留存率

select sum(if(liu='留存',1,0))/count(device_id) avg_ret from (select device_id, date, if(datediff(date,lead(date,1)over(partition by device_id order by ...

2025-03-25

0 97