Title Bouts through the Years

Easy · UFC · Tables: fights

Count bouts with title_bout = 'True' in each calendar year. Extract an integer year from the ISO date. Include only years with at least one title bout. Return columns year, title_bouts, 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.

More SQL practice problems