```json { "queries": [ { "query": "SELECT \"Name\", \"Points\", \"Assoc\" FROM ittf_rankings WHERE \"Rank\" = '1' ORDER BY \"YearNum\" DESC, \"MonthNum\" DESC, \"WeekNum\" DESC LIMIT 20", "description": "Most recent world number one ranked players with their points and country association." }, { "query": "SELECT \"Assoc\", COUNT(*) AS player_count FROM ittf_rankings WHERE \"Rank\" IS NOT NULL GROUP BY \"Assoc\" ORDER BY player_count DESC LIMIT 15", "description": "Countries with the most ranked table tennis players across all time periods." }, { "query": "SELECT \"Name\", \"Points\", \"Assoc\", \"YearNum\" FROM ittf_rankings_women WHERE \"Rank\" = '1' ORDER BY \"YearNum\" DESC, \"MonthNum\" DESC LIMIT 20", "description": "Recent women's world number one players showing their points, country, and year." }, { "query": "SELECT \"YearNum\", COUNT(DISTINCT \"Name\") AS unique_players FROM ittf_rankings WHERE \"YearNum\" IS NOT NULL GROUP BY \"YearNum\" ORDER BY \"YearNum\" DESC LIMIT 20", "description": "Number of unique players ranked each year, showing growth in competitive participation." }, { "query": "SELECT \"Name\", \"Assoc\", \"Rank\", \"Points\" FROM ittf_rankings_women ORDER BY \"YearNum\" DESC, \"MonthNum\" DESC, \"WeekNum\" DESC, CAST(\"Rank\" AS INTEGER) LIMIT 10", "description": "Current top 10 women's table tennis players with their ranking and points." }, { "query": "SELECT \"Assoc\", COUNT(*) AS rankings_count FROM ittf_rankings_women WHERE \"Assoc\" IS NOT NULL GROUP BY \"Assoc\" ORDER BY rankings_count DESC LIMIT 15", "description": "Countries with most women's ranking entries, indicating strong female table tennis programs." }, { "query": "SELECT \"Name\", COUNT(DISTINCT \"YearNum\") AS years_ranked FROM ittf_rankings WHERE \"Name\" IS NOT NULL GROUP BY \"Name\" ORDER BY years_ranked DESC LIMIT 20", "description": "Players with the longest careers, measured by number of years appearing in rankings." }, { "query": "SELECT \"YearNum\", \"MonthNum\", COUNT(*) AS total_ranked FROM ittf_rankings WHERE \"YearNum\" IS NOT NULL AND \"MonthNum\" IS NOT NULL GROUP BY \"YearNum\", \"MonthNum\" ORDER BY \"YearNum\" DESC, \"MonthNum\" DESC LIMIT 20", "description": "Total number of ranked players per month, showing recent trends in ranking participation." }, { "query": "SELECT \"Name\", \"Rank\", \"Points\", \"Assoc\" FROM ittf_rankings ORDER BY \"YearNum\" DESC, \"MonthNum\" DESC, \"WeekNum\" DESC, CAST(\"Rank\" AS INTEGER) LIMIT 10", "description": "Most recent top 10 men's table tennis players with their current ranking and points." }, { "query": "SELECT \"Gender\", COUNT(*) AS total_entries FROM ittf_rankings WHERE \"Gender\" IS NOT NULL GROUP BY \"Gender\"", "description": "Distribution of ranking entries by gender across the entire dataset." } ] } ```