题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
SELECT avg(if(datediff(t1.date, t1.date_lag) = 1, 1, 0)) AS avg_ret FROM( SELECT pd.device_id , pd.`date` , lag(pd.`date`) OVER (PARTITION BY pd.device_id ORDER BY pd.`date`) AS date_lag FROM question_practice_detail AS pd GROUP BY pd.device_id , pd.`date` ) as t1
华为技术有限公司工作强度 1285人发布