```json { "queries": [ { "query": "SELECT result, COUNT(*) AS match_count FROM boxing_matches WHERE result IS NOT NULL GROUP BY result ORDER BY match_count DESC", "description": "Distribution of match outcomes showing wins, losses, and draws." }, { "query": "SELECT decision, COUNT(*) AS count FROM boxing_matches WHERE decision IS NOT NULL GROUP BY decision ORDER BY count DESC LIMIT 10", "description": "Most common decision types in boxing matches." }, { "query": "SELECT stance_A, stance_B, COUNT(*) AS matches FROM boxing_matches WHERE stance_A IS NOT NULL AND stance_B IS NOT NULL GROUP BY stance_A, stance_B ORDER BY matches DESC LIMIT 10", "description": "Most frequent stance matchups between fighters A and B." }, { "query": "SELECT age_A, age_B, height_A, height_B, weight_A, weight_B, result FROM boxing_matches WHERE age_A IS NOT NULL AND age_B IS NOT NULL LIMIT 20", "description": "Sample of match records showing fighter attributes and outcomes." }, { "query": "SELECT won_A, lost_A, drawn_A, kos_A, result FROM boxing_matches WHERE won_A IS NOT NULL AND result IS NOT NULL LIMIT 15", "description": "Fighter A records and match results for recent bouts." }, { "query": "SELECT stance_A, COUNT(*) AS fighter_count FROM boxing_matches WHERE stance_A IS NOT NULL GROUP BY stance_A ORDER BY fighter_count DESC", "description": "Distribution of fighting stances for fighter A across all matches." }, { "query": "SELECT result, decision, COUNT(*) AS count FROM boxing_matches WHERE result IS NOT NULL AND decision IS NOT NULL GROUP BY result, decision ORDER BY count DESC LIMIT 10", "description": "Breakdown of match results by decision type." }, { "query": "SELECT judge1_A, judge1_B, judge2_A, judge2_B, judge3_A, judge3_B, result FROM boxing_matches WHERE judge1_A IS NOT NULL AND judge1_B IS NOT NULL LIMIT 10", "description": "Sample of judge scorecards showing points awarded to each fighter." }, { "query": "SELECT reach_A, reach_B, height_A, height_B, result FROM boxing_matches WHERE reach_A IS NOT NULL AND reach_B IS NOT NULL LIMIT 15", "description": "Physical measurements and outcomes for fighters with recorded reach data." }, { "query": "SELECT weight_A, weight_B, result, decision FROM boxing_matches WHERE weight_A IS NOT NULL AND weight_B IS NOT NULL LIMIT 20", "description": "Fighter weights and match outcomes across different weight classes." } ] } ```