select tbb.tag, tbb.avg_play_progress from ( select tb.tag, concat ( format ( ( case when sum(rate) / count(tb.video_id) > 0.6 then sum(rate) / count(tb.video_id) * 100 else null end ), 2 ), '%' ) as avg_play_progress from ( select a.video_id, b.tag, ( case when TIMESTAMPDIFF (SECOND, start_time,...