Yosangta

分类

/ 注册

全部文章（共23篇）

题解 | 国庆期间近7日日均取消订单量

with dt as( select distinct date(order_time) dt from tb_get_car_order where date_format(order_time,'%m%d') between '1001' and'1003' ) sel...

2025-07-31

1 41

题解 | 店铺901国庆期间的7日动销率和滞销率

with t1 as( select s2.product_id, shop_id, date(event_time) dt from tb_order_overall s1 join tb_or...

2025-06-25

0 43

题解 | 10月的新户客单价和获客成本

with t1 as( select s1.order_id, total_amount temp_amount, sum(price*cnt) - total_amount temp_cost from tb_ord...

2025-06-25

0 47

题解 | 连续签到领金币

with t1 as( select uid, date(in_time) dt, row_number() over(partition by uid,month(date(in_time)) order by date(in_time) ...

2025-06-23

0 62

题解 | 每天的日活数及新用户占比

with fresher_detail as( select uid, min(date(in_time)) first_open from tb_user_log group by 1 ) ,dau_detail as( selec...

2025-06-23

0 50

题解 | 统计活跃间隔对用户分级结果

with parameters as( select date(max(out_time)) cur_date, date_sub(date(max(out_time)),interval 6 day) cur_7, date_sub(date...

2025-06-23

0 39

题解 | 2021年11月每天新用户的次日留存率

with t1 as( SELECT uid, in_time event_time from tb_user_log union all select uid, out_time event_time ...

2025-06-23

0 51

题解 | 国庆期间每类视频点赞量和转发量

with t1 as ( select video_id,author,tag,end_time,if_follow,if_like,if_retweet,comment_id from tb_video_info s1 left join ...

2025-06-19

0 60

题解 | 平均播放进度大于60%的视频类别

select tag, concat(round(avg(case when timestampdiff(second,start_time,end_time)/duration >=1 then 1 else timestampdiff(second,start_ti...

2025-06-18

0 37

题解 | 各个视频的平均完播率

select s1.video_id, coalesce(round(count(s2.video_id)/nullif(count(s1.video_id),0),3),0) avg_comp_play_rate from tb_user_video_log s1 le...

2025-06-18

0 54