```json { "queries": [ { "query": "SELECT f_boxer, COUNT(*) AS total_fights, SUM(CASE WHEN f_boxer_result IS NOT NULL THEN 1 ELSE 0 END) AS recorded_results FROM cleandata GROUP BY f_boxer ORDER BY total_fights DESC LIMIT 10", "description": "Top 10 boxers by number of fights with their recorded results count." }, { "query": "SELECT f_boxer_stance, COUNT(*) AS fights FROM cleandata WHERE f_boxer_stance IS NOT NULL GROUP BY f_boxer_stance ORDER BY fights DESC", "description": "Distribution of boxing stances among first boxers in matches." }, { "query": "SELECT f_boxer, s_boxer, f_boxer_result, matchRounds, fightEnd FROM cleandata WHERE fightEnd IS NOT NULL ORDER BY \"Unnamed: 0\" DESC LIMIT 15", "description": "Most recent 15 fights showing boxers, results, rounds, and how the fight ended." }, { "query": "SELECT fightEnd, COUNT(*) AS occurrences FROM cleandata WHERE fightEnd IS NOT NULL GROUP BY fightEnd ORDER BY occurrences DESC", "description": "How fights typically end, ranked by frequency of each ending type." }, { "query": "SELECT f_boxer, f_boxer_age, f_boxer_height, f_boxer_reach, f_boxer_won, f_boxer_lost FROM cleandata WHERE f_boxer_age IS NOT NULL ORDER BY \"Unnamed: 0\" DESC LIMIT 10", "description": "Physical stats and records for first boxers in the 10 most recent matches." }, { "query": "SELECT matchRounds, COUNT(*) AS fight_count FROM cleandata WHERE matchRounds IS NOT NULL GROUP BY matchRounds ORDER BY fight_count DESC", "description": "Distribution of scheduled match rounds across all recorded fights." }, { "query": "SELECT f_boxer, s_boxer, f_boxer_result, s_boxer_result FROM cleandata WHERE f_boxer_result IS NOT NULL AND s_boxer_result IS NOT NULL LIMIT 20", "description": "Sample of 20 fights showing both boxers and their respective match results." }, { "query": "SELECT f_boxer_stance, s_boxer_stance, COUNT(*) AS matchups FROM cleandata WHERE f_boxer_stance IS NOT NULL AND s_boxer_stance IS NOT NULL GROUP BY f_boxer_stance, s_boxer_stance ORDER BY matchups DESC LIMIT 10", "description": "Most common stance matchups between first and second boxers." }, { "query": "SELECT f_boxer, COUNT(DISTINCT s_boxer) AS unique_opponents FROM cleandata WHERE s_boxer IS NOT NULL GROUP BY f_boxer ORDER BY unique_opponents DESC LIMIT 10", "description": "Boxers who faced the most different opponents in recorded matches." }, { "query": "SELECT f_boxer_ranking, s_boxer_ranking, COUNT(*) AS fights FROM cleandata WHERE f_boxer_ranking IS NOT NULL AND s_boxer_ranking IS NOT NULL GROUP BY f_boxer_ranking, s_boxer_ranking ORDER BY fights DESC LIMIT 10", "description": "Most frequent ranking matchups between first and second boxers." } ] } ```