A 2025 Results Ledger

Easy · UFC · Tables: fights

List the latest 20 fight rows dated in 2025 whose winner is 'Red' or 'Blue'. Return the winner label as winning_corner; it is a corner label, not a fighter name. Return columns date, r_fighter, b_fighter, winning_corner, in that order. Order by date descending, then r_fighter and b_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.

More SQL practice problems