<invoke name="tool_call"> <parameter name="action">tool_call</parameter> <parameter name="reasoning">Compute min/max/mean/median/stddev/IQR for all numeric columns in one UNION ALL query.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"purpose":"Distribution summary for every numeric column","source":"raw","sql":"SELECT 'players_man_.number_of_matches' AS col, COUNT(v) AS n, MIN(v) AS min, MAX(v) AS max, AVG(v) AS mean, MEDIAN(v) AS median, STDDEV_SAMP(v) AS stddev, QUANTILE_CONT(v,0.25) AS p25, QUANTILE_CONT(v,0.75) AS p75 FROM (SELECT CAST(number_of_matches AS DOUBLE) v FROM raw.players_man_) UNION ALL SELECT 'players_tournament_man_.year', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT CAST(year AS DOUBLE) v FROM raw.players_tournament_man_) UNION ALL SELECT 'raw_kaggle.Rk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT Rk v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.vRk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT vRk v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.TP', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT TP v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.Aces', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT Aces v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.DFs', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT DFs v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.SP', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT SP v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.1SP', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT \"1SP\" v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.2SP', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT \"2SP\" v FROM raw.raw_kaggle) UNION ALL SELECT 'raw_kaggle.vA', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT vA v FROM raw.raw_kaggle) UNION ALL SELECT 'return_kaggle.Rk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT Rk v FROM raw.return_kaggle) UNION ALL SELECT 'return_kaggle.vRk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT vRk v FROM raw.return_kaggle) UNION ALL SELECT 'serve_kaggle.Rk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT TRY_CAST(Rk AS DOUBLE) v FROM raw.serve_kaggle) UNION ALL SELECT 'serve_kaggle.vRk', COUNT(v), MIN(v), MAX(v), AVG(v), MEDIAN(v), STDDEV_SAMP(v), QUANTILE_CONT(v,0.25), QUANTILE_CONT(v,0.75) FROM (SELECT TRY_CAST(vRk AS DOUBLE) v FROM raw.serve_kaggle)"}</parameter> </invoke>