Hard · UFC · Tables: fights
Normalize each decisive bout (winner 'Red' or 'Blue') into one row per corner. For each nonblank fighter name with at least ten decisive appearances, count appearances and wins and compute a win percentage rounded to two decimals. Return the top twenty. Exclude draws and no contests entirely and treat source names as exact identifiers. Do not use pre-bout career totals. Return columns fighter, decided_bouts, wins, win_pct, in that order. Order by rounded win_pct descending, then wins descending, then fighter ascending; return twenty rows. 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.