Hard · UFC · Tables: fights
For each non-NULL weight_class, count each winning fighter's wins from decisive bouts only. Map Red to r_fighter and Blue to b_fighter; exclude NULL or blank names. Rank totals within each class with DENSE_RANK, wins descending, and keep the top three distinct win totals including all ties. Treat names exactly as recorded, and keep a fighter's different weight classes separate. Return columns weight_class, fighter, wins, win_rank, in that order. Order by weight_class ascending, then win_rank ascending, then fighter 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.