```json { "queries": [ { "query": "SELECT \"Assoc\", COUNT(*) AS player_count FROM ittf_player_info GROUP BY \"Assoc\" ORDER BY player_count DESC LIMIT 15", "description": "Top 15 countries by number of registered table tennis players." }, { "query": "SELECT \"Gender\", COUNT(*) AS total FROM ittf_player_info WHERE \"Gender\" IS NOT NULL GROUP BY \"Gender\"", "description": "Distribution of players by gender in the ITTF database." }, { "query": "SELECT \"Playing hand\", COUNT(*) AS count FROM ittf_player_info WHERE \"Playing hand\" IS NOT NULL GROUP BY \"Playing hand\" ORDER BY count DESC", "description": "Number of left-handed versus right-handed players." }, { "query": "SELECT \"Playing style\", COUNT(*) AS players FROM ittf_player_info WHERE \"Playing style\" IS NOT NULL GROUP BY \"Playing style\" ORDER BY players DESC", "description": "Most common playing styles among registered players." }, { "query": "SELECT \"Grip\", COUNT(*) AS total FROM ittf_player_info WHERE \"Grip\" IS NOT NULL GROUP BY \"Grip\" ORDER BY total DESC", "description": "Distribution of grip types used by table tennis players." }, { "query": "SELECT \"Birth year\", COUNT(*) AS players FROM ittf_player_info WHERE \"Birth year\" IS NOT NULL GROUP BY \"Birth year\" ORDER BY \"Birth year\" DESC LIMIT 20", "description": "Number of players born in each of the most recent 20 years." }, { "query": "SELECT \"Activity\", COUNT(*) AS count FROM ittf_player_info WHERE \"Activity\" IS NOT NULL GROUP BY \"Activity\" ORDER BY count DESC", "description": "Breakdown of players by activity status in the ITTF system." }, { "query": "SELECT \"Name\", \"Assoc\", \"Birth year\", \"Playing hand\" FROM ittf_player_info WHERE \"Playing style\" IS NOT NULL LIMIT 20", "description": "Sample of 20 player profiles with their country, birth year, and playing hand." }, { "query": "SELECT \"Assoc\", \"Gender\", COUNT(*) AS players FROM ittf_player_info WHERE \"Gender\" IS NOT NULL AND \"Assoc\" IS NOT NULL GROUP BY \"Assoc\", \"Gender\" ORDER BY players DESC LIMIT 20", "description": "Top 20 country-gender combinations by player count." }, { "query": "SELECT \"Playing hand\", \"Playing style\", COUNT(*) AS combo_count FROM ittf_player_info WHERE \"Playing hand\" IS NOT NULL AND \"Playing style\" IS NOT NULL GROUP BY \"Playing hand\", \"Playing style\" ORDER BY combo_count DESC LIMIT 10", "description": "Most common combinations of playing hand and playing style." } ] } ```