SELECT t2.video_id, CAST((100*t2.finish_rate + 5*t2.like_count + 3*t2.comment_count + 2*t2.retweet_count) * t2.fresh AS SIGNED) AS hot_index FROM ( SELECT t1.video_id, global_max_date.max_date, 1 / (DATEDIFF(global_max_date.max_date,MAX(DATE(t1.end_time))) + 1) AS fresh, SUM(t1.if_finish) / COUNT(1)...