数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

题解 | SaaS产品高价值用户活跃度分析

with t1 as ( select distinct u.user_id,user_name,registration_date,plan_type,event_id,event_type,event_timestamp from users u join user_events...

2026-02-05

0 9

题解 | 游戏平台新玩家消费与进阶行为分析

把高阶玩家打成高级玩家了找半天错服了 select player_id,username,level current_level, if(level>=30,'高阶玩家','新秀玩家') player_category, round(sum(cost),2) total_april_spe...

2026-02-03

0 10

题解 | SaaS平台企业客户新功能采纳度分析

with data as ( select team_id,team_name,count(*) april_usage_count, if(count(*)>50,'深度采纳团队','普通采纳团队') adoption_category from ( ...

2026-02-03

1 12

题解 | 在线教育平台活跃学员课程评价分析

排序规则有点模糊不清容易出错 with data_1 as ( select user_id,round(avg(rating),2) average_rating, if(round(avg(rating),2)>=4.0,'优质反馈学员','普通反馈学员') feedb...

2026-02-03

0 8

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

with t1 as ( select tag,date(start_time) df, sum(sum(if_like))over(partition by tag rows 6 preceding) sum_like_cnt_7d, max(sum(if_retweet)...

2026-01-30

0 16

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

with t1 as ( select author,mid(start_time,1,7) month, count(start_time) count_, sum(if(if_follow=1,1,0)) yes, sum(if(if_follow=2,1,0))...

2026-01-30

0 10

题解 | 每类视频近一个月的转发量/率

select tag,sum(if_retweet) retweet_cnt,round(sum(if_retweet)/count(*),3) retweet_rate from tb_user_video_log tl left join tb_video_info ti on tl.video...

2026-01-29

0 13

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

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

2026-01-29

0 12

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

with t1 as ( select tl.video_id,count(*) comp_play_cnt from tb_user_video_log tl left join tb_video_info ti on tl.video_id = ti.video_id w...

2026-01-29

0 14

题解 | 批量插入数据

insert into actor values (1,'PENELOPE','GUINESS','2006-02-15 12:34:33'), (2,'NICK','WAHLBERG','2006-02-15 12:34:33');

2026-01-28

0 13