JanisZhan

题解

/ 注册

全部文章 / 题解（共33篇）

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

select info.tag,sum(log.if_retweet) as retweet_cut, round((sum(log.if_retweet)/count(info.tag)),3) as retweet_rate from tb_video_info info righ...

Mysql

2022-06-22

3 394

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

select info.tag,concat ( round(avg(if(timestampdiff(second,log.start_time,log.end_time)>=info.duration,100, timestampdiff(second,log.start_time,log...

Mysql

2022-06-22

1 349

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

select log.video_id, round( sum(CASE WHEN log.end_time-log.start_time>=info.duration THEN 1 ELSE 0 END) /count(log.video_id),3) as avg...

Mysql

2022-06-22

1 284