Medium · UFC · Tables: fights
For each non-NULL weight_class, count finish = 'KO/TKO' as ko_tko, finish = 'SUB' as submissions, and finish in ('U-DEC','S-DEC','M-DEC') as decisions. Other or missing finishes contribute zero. Keep every weight class in the historical data. Return columns weight_class, ko_tko, submissions, decisions, in that order. Order by 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.