WITH play_info AS( SELECT u.video_id, TIMESTAMPDIFF(SECOND, start_time, end_time) AS play_time, v.tag, v.duration, CASE WHEN TIMESTAMPDIFF(SECOND, start_time, end_time) / v.duration < 1 THEN TIMESTAMPDIFF(SECOND, start_time, end_time) / v.duration ELSE 1 END AS play_progress FROM tb_user_video_lo...
