汤圆r

分类

/ 注册

全部文章（共2篇）

题解 | 25年美团-骑手配送履约分层留存与时段热力矩阵

with t as ( select order_id, d.rider_id, TIMESTAMPDIFF(SECOND, pickup_time, deliver_time) / 60.0 duration, case when hour...

2026-04-29

0 13

题解 | 25年得物-潮鞋新品发售后 N 日复购留存矩阵

select t0.series_id ,series_name ,count(distinct t0.user_id) first_buyer_cnt ,round(count(distinct t1.user_id)/count(distinct t0.user_id),...

2026-04-29

0 9