LittleLily

分类

题解(25)

/ 注册

全部文章（共3篇）

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

SELECT tag, SUM(if_retweet) AS retweet_cut, ROUND(SUM(if_retweet)/COUNT(video_id),3) AS retweet_rate FROM tb_user_video_log log JOIN tb_vi...

Mysql 数据库

2022-05-06

0 291

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

SELECT tag, CONCAT(ROUND(AVG(IF( TIME_TO_SEC(end_time)-TIME_TO_SEC(start_time)>=info.duration, 100, (TIME_TO_SEC(end_time)-TIME...

Mysql 数据库

2022-05-06

0 353

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

SELECT tb.video_id, ROUND(SUM(IF( TIME_TO_SEC(end_time)-TIME_TO_SEC(start_time) >= info.duration, 1, 0 ))/COUNT(tb.video_i...

Mysql 数据库

2022-05-06

0 355