Missing Finish Information

Easy · UFC · Tables: fights

Count rows whose finish is SQL NULL, empty, or whitespace-only. Do not infer the finish from winner or finish_details. Return columns missing_finishes, in that order. Return exactly one row. 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