不做造粪机器

分类

/ 注册

全部文章（共95篇）

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

select v.author, date_format(u.start_time,'%Y-%m') month, round(avg(if(if_follow=2,-1,if_follow)),3) fans_growth_rate, sum(sum(if(if_follow=2,-1,if_fo...

2024-08-19

0 141

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

select tvi.tag, sum(tuvl.if_retweet) retweet_cut, round(avg(tuvl.if_retweet),3) retweet_rate from tb_video_info tvi inner join tb_user_video_log tuv...

2024-08-18

0 109

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

select a.tag, concat(round(a.avg_play_progress*100,2),'%') avg_play_progress from (select tvi.tag, avg(if(timestampdiff(second,tuvl.start_time,tuvl.en...

2024-08-18

0 117

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

select tuvl.video_id, round(avg(if(tuvl.end_time-tuvl.start_time>=tvi.duration,1,0)),3) avg_comp_play_rate from tb_user_video_log tuvl left join tb...

2024-08-18

0 103

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

select s.name,a.cnt from( select subject_id, count(*) cnt from submission where create_time=date_format(now(),'%Y-%m-%d') group by su...

2024-08-07

0 99

题解 | #网易云音乐推荐(网易校招笔试真题)#

select distinct a.music_name from (select distinct m.music_name, ml.music_id from music m inner join music_likes ml on m.id=ml.music_id where m.id not...

2024-08-07

0 141

题解 | #商品交易(网易校招笔试真题)#

select a.goods_id id,g.name,g.weight,a.total from (select goods_id, sum(count) total from trans group by goods_id) a inner join goods g on g.id=a.goo...

2024-08-07

0 131

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

select b.user_id,u.name,b.grade_num from (select user_id,sum(if(type='add',grade_num,-1*grade_num)) grade_num from grade_info group by user_id) b lef...

2024-08-07

0 126

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

select u.id,u.name, c.grade_num from( select a.user_id,a.grade_num from (select user_id,sum(grade_num) grade_num from grade_info group by use...

2024-07-31

0 208

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

select u.name, sum(g.grade_num) over(partition by g.user_id) grade_num from grade_info g right join user u on g.user_id=u.id order by grade_num desc ...

2024-07-31

0 108