Easy · UFC · Tables: fights
Count historical fight rows by non-NULL weight_class. Preserve the source labels exactly. Return columns weight_class, bouts, in that order. Order by bouts descending, 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.