Medium · UFC · Tables: fights
Keep bouts with numeric total_fight_time_secs greater than zero and non-NULL weight_class. For each weight class with at least 50 retained bouts, return their count and average duration rounded to two decimals. Do not estimate time for missing rows or interpret this as a full-career average. Return columns weight_class, timed_bouts, avg_seconds, in that order. Order by rounded avg_seconds ascending, then weight_class ascending. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text. Use only the historical fights table (2010–March 2026); this is not complete UFC history or a live schedule.