{
    "action": "tool_call",
    "reasoning": "Count exact full-row duplicates in each of the 5 tables by comparing total rows to distinct rows, in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT 'raw_kaggle' AS tbl, (SELECT COUNT(*) FROM raw.raw_kaggle) AS total_rows, (SELECT COUNT(*) FROM (SELECT DISTINCT * FROM raw.raw_kaggle)) AS distinct_rows UNION ALL SELECT 'return_kaggle', (SELECT COUNT(*) FROM raw.return_kaggle), (SELECT COUNT(*) FROM (SELECT DISTINCT * FROM raw.return_kaggle)) UNION ALL SELECT 'serve_kaggle', (SELECT COUNT(*) FROM raw.serve_kaggle), (SELECT COUNT(*) FROM (SELECT DISTINCT * FROM raw.serve_kaggle)) UNION ALL SELECT 'players_tournament_man_', (SELECT COUNT(*) FROM raw.players_tournament_man_), (SELECT COUNT(*) FROM (SELECT DISTINCT * FROM raw.players_tournament_man_)) UNION ALL SELECT 'players_man_', (SELECT COUNT(*) FROM raw.players_man_), (SELECT COUNT(*) FROM (SELECT DISTINCT * FROM raw.players_man_))",
        "purpose": "Count exact full-row duplicates in each of the 5 tables",
        "source": "raw"
    }
}