Medium · UFC · Tables: fights
For each calendar year, keep only winner labels 'Red' and 'Blue'. Count decided_bouts and red_wins, and calculate 100.0 times red_wins divided by decided_bouts, rounded to two decimals. Return integer year. This is descriptive data, not evidence that corner assignment causes wins. Return columns year, decided_bouts, red_wins, red_win_pct, in that order. Order by year 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.