猫咪咪_1222

分类

题解(2)

/ 注册

全部文章（共2篇）

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

select b.tag ,count(if(a.if_retweet = 1,1,NULL)) as retweet_cut ,round(count(if(a.if_retweet = 1,1,NULL))/count(1),3) as retweet_rate...

Mysql

2022-03-24

0 335

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

select tag ,concat(round(avg(progress)*100,2),'%') as avg_play_progress from( select a.video_id ,b.tag as tag ,(case when ti...

Mysql

2022-03-24

0 317