{
    "queries": [
        {
            "query": "SELECT \"Name\", COUNT(*) AS matches FROM raw_kaggle GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Players with the most recorded match rows in the raw data."
        },
        {
            "query": "SELECT \"Surface\", COUNT(*) AS matches, AVG(\"Aces\") AS avg_aces FROM raw_kaggle WHERE \"Aces\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Match counts and average aces per match by court surface."
        },
        {
            "query": "SELECT \"Tournament\", COUNT(*) AS matches FROM raw_kaggle GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Tournaments with the most match records."
        },
        {
            "query": "SELECT \"Name\", SUM(\"Aces\") AS total_aces, AVG(\"DFs\") AS avg_double_faults FROM raw_kaggle WHERE \"Aces\" IS NOT NULL AND \"DFs\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Players with the most career aces and their average double faults."
        },
        {
            "query": "SELECT \"Name\", \"Date\", \"Tournament\", \"Rd\", \"Score\", \"Aces\" FROM raw_kaggle WHERE \"Name\" = 'Novak Djokovic' AND \"Aces\" IS NOT NULL ORDER BY \"Aces\" DESC LIMIT 10",
            "description": "Novak Djokovic's matches with the most aces."
        },
        {
            "query": "SELECT \"name\", \"year\", \"tournament\", \"rounds\" FROM players_tournament_man_ WHERE \"name\" = 'Rafael Nadal' AND \"tournament\" = 'Roland Garros' ORDER BY \"year\" DESC LIMIT 20",
            "description": "Rafael Nadal's Roland Garros results by year."
        },
        {
            "query": "SELECT \"tournament\", COUNT(*) AS finals FROM players_tournament_man_ WHERE \"rounds\" = '[''F'']' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Tournaments with the most finalist entries."
        },
        {
            "query": "SELECT \"name\", \"number_of_matches\" FROM players_man_ ORDER BY \"number_of_matches\" DESC LIMIT 10",
            "description": "Players with the highest number of matches played."
        },
        {
            "query": "SELECT \"year\", COUNT(*) AS entries FROM players_tournament_man_ GROUP BY 1 ORDER BY 1",
            "description": "Number of player tournament entries each year."
        }
    ]
}