```json { "queries": [ { "query": "SELECT Player1, COUNT(*) AS matches FROM table_tennis_sept2022 WHERE Player1 IS NOT NULL GROUP BY Player1 ORDER BY matches DESC LIMIT 10", "description": "Top 10 players by number of matches played as Player1." }, { "query": "SELECT Player2, COUNT(*) AS matches FROM table_tennis_sept2022 WHERE Player2 IS NOT NULL GROUP BY Player2 ORDER BY matches DESC LIMIT 10", "description": "Top 10 players by number of matches played as Player2." }, { "query": "SELECT HomeWinner, COUNT(*) AS count FROM table_tennis_sept2022 WHERE HomeWinner IS NOT NULL GROUP BY HomeWinner ORDER BY count DESC", "description": "Distribution of home winners across all matches." }, { "query": "SELECT Sets_P1, Sets_P2, COUNT(*) AS matches FROM table_tennis_sept2022 WHERE Sets_P1 IS NOT NULL AND Sets_P2 IS NOT NULL GROUP BY Sets_P1, Sets_P2 ORDER BY matches DESC", "description": "Most common final set scores in matches." }, { "query": "SELECT Date, Player1, Player2, Sets_P1, Sets_P2 FROM table_tennis_sept2022 WHERE Date IS NOT NULL ORDER BY Date DESC LIMIT 20", "description": "Most recent 20 matches with players and final scores." }, { "query": "SELECT Player1, Player2, P1_G1, P2_G1, P1_G2, P2_G2, P1_G3, P2_G3 FROM table_tennis_sept2022 WHERE Sets_P1 IS NOT NULL LIMIT 15", "description": "Sample of 15 matches showing game-by-game scores." }, { "query": "SELECT COUNT(*) AS total_matches, COUNT(DISTINCT Player1) AS unique_p1, COUNT(DISTINCT Player2) AS unique_p2 FROM table_tennis_sept2022", "description": "Total matches and number of unique players in each position." }, { "query": "SELECT Date, COUNT(*) AS matches FROM table_tennis_sept2022 WHERE Date IS NOT NULL GROUP BY Date ORDER BY matches DESC LIMIT 10", "description": "Dates with the most matches played." }, { "query": "SELECT Player1, Sets_P1, Sets_P2 FROM table_tennis_sept2022 WHERE Sets_P1 IS NOT NULL AND Sets_P2 IS NOT NULL ORDER BY Date LIMIT 20", "description": "First 20 matches showing Player1 and set outcomes." }, { "query": "SELECT Time, Player1, Player2, Sets_P1, Sets_P2 FROM table_tennis_sept2022 WHERE Time IS NOT NULL ORDER BY Time LIMIT 15", "description": "Sample matches ordered by time of day." } ] } ```