JanisZhan

题解

/ 注册

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

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

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