牛客101781186号

分类

题解(2)

/ 注册

全部文章（共2篇）

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

count(distinct device_id) as did_cnt ,COUNT(question_id) FROM question_practice_detail where -- Year(date) ='2021' and month(date)= '8' -- date_forma...

Mysql

2022-01-30

27 488

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

正规的连续天计算，应该排序： WITH a AS ( SELECT DISTINCT device_id , date , row_number() OVER (PARTITION BY device_id ORDER BY date) rn FR...

Mysql

2022-01-29

3 337