牛客63343748号

分类

/ 注册

全部文章（共39篇）

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

select author, t3.month, round(sum(if(if_follow=2,-1,if_follow))/count(*),3) as fans_growth_rate, max(cnt) as total_fans from ( select...

2025-05-05

0 34

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

select tag, sum(if_retweet) as cnt, round(avg(if_retweet),3) as retweet_rate from tb_user_video_log as t1 join tb_video_info as t2 on ...

2025-04-22

0 38

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

select tag, concat(round(avg(if(timestampdiff(second,start_time,end_time)/duration>1,1,timestampdiff(second,start_time,end_time)/duration)*100...

2025-04-22

0 34

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

select t1.video_id, round(avg(if(timestampdiff(second,start_time,end_time)>=t2.duration,1,0)),3) as vg_comp_play_rate from tb_user_video_lo...

2025-04-22

0 49

题解 | 今天的刷题量(一)

select name, count(*) as cnt from submission as s1 join subject as s2 on s1.subject_id=s2.id where create_time=CURDATE() group by n...

2025-04-22

0 28

题解 | 获得积分最多的人(三)

select id, name, t1.grade_num from ( select user_id, sum(case when type='add' then grade_num else concat('-',grade_num) end...

2025-04-22

0 35

题解 | 实习广场投递简历分析(三)

select t1.job, first_year_mon, first_year_cnt, second_year_mon, second_year_cnt from ( select job, date_format(date,'%Y...

2025-04-21

0 37

题解 | 实习广场投递简历分析(二)

select t1.job, mon, sum(t1.num) as cnt from ( select job,date_format(date,'%Y-%m') as mon,num from resume_info where year(date)=2025 )...

2025-04-21

0 35

题解 | 牛客的课程订单分析(六)

select t1.id, is_group_buy, client_name from ( select o.id, is_group_buy, name as client_name, count(*) over(partition by ...

2025-04-18

0 32

题解 | 牛客的课程订单分析(五)

with t1 as (select user_id, min(date) as first_buy_date, count(*) as cnt from order_info where date>'2025-10-15' and product_name in (...

2025-04-17

0 40