<invoke name="tool_call"> <parameter name="reasoning">Compute top values and frequencies for the main categorical columns (Surface, Rd, Tournament, Name) in raw_kaggle in one query.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH t AS (SELECT 'Surface' AS col, CAST(Surface AS VARCHAR) AS value, COUNT(*) AS n FROM raw.raw_kaggle GROUP BY 2 UNION ALL SELECT 'Rd', CAST(Rd AS VARCHAR), COUNT(*) FROM raw.raw_kaggle GROUP BY 2 UNION ALL SELECT 'Tournament', Tournament, COUNT(*) FROM raw.raw_kaggle GROUP BY 2 UNION ALL SELECT 'Name', Name, COUNT(*) FROM raw.raw_kaggle GROUP BY 2), r AS (SELECT col, value, n, ROUND(100.0*n/SUM(n) OVER (PARTITION BY col),2) AS pct, ROW_NUMBER() OVER (PARTITION BY col ORDER BY n DESC) AS rk FROM t) SELECT col, value, n, pct FROM r WHERE rk<=10 ORDER BY col, n DESC","purpose":"Top values and frequency of main categorical columns in raw_kaggle","source":"raw"}</parameter> </invoke>