WITH t AS ( SELECT tu.video_id AS video_id, AVG(IF(timestampdiff(second, start_time, end_time) >= duration, 1, 0)) AS full_play, SUM(if_like) AS likesum, COUNT(comment_id) AS commentsum, SUM(if_retweet) AS retweetsum, 1 / (datediff( ...