荆天明201908291552707
荆天明201908291552707
全部文章
分类
题解(31)
归档
标签
去牛客网
登录
/
注册
荆天明201908291552707的博客
全部文章
(共33篇)
题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#
(select tv.author, DATE_FORMAT(tu.start_time, "%Y-%m") month, round( sum( case when if_follow = 2 then -1 else if_foll...
Mysql
2022-05-29
0
161
题解 | #各个视频的平均完播率#
SELECT M.tag, concat( cast( ( sum( realTime ) / sum( M.duration ) * 100 ) AS DECIMAL ( 10, 2 ) ), "%" ) as avg_play_progress FROM ( SELECT ...
Mysql
2022-05-22
0
154
题解 | #各个视频的平均完播率#
select tv.video_id as video_id, round( avg( case when (tu.end_time - tu.start_time) >= tv.duration then 1 else 0 ...
Mysql
2022-05-18
0
145
首页
上一页
1
2
3
4
下一页
末页