<invoke name="tool_call"> <parameter name="reasoning">Compute min/max/mean/median/stddev/quartiles for all numerically typed columns in one UNION query.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"purpose":"Distribution summary for all numeric columns","source":"raw","sql":"SELECT 'players_man_.number_of_matches' AS col, COUNT(number_of_matches) AS n, CAST(MIN(number_of_matches) AS DOUBLE) AS mn, CAST(MAX(number_of_matches) AS DOUBLE) AS mx, AVG(number_of_matches) AS mean, MEDIAN(number_of_matches) AS med, STDDEV(number_of_matches) AS sd, QUANTILE_CONT(number_of_matches,0.25) AS q1, QUANTILE_CONT(number_of_matches,0.75) AS q3 FROM raw.players_man_ UNION ALL SELECT 'players_tournament_man_.year', COUNT(year), MIN(year), MAX(year), AVG(year), MEDIAN(year), STDDEV(year), QUANTILE_CONT(year,0.25), QUANTILE_CONT(year,0.75) FROM raw.players_tournament_man_ UNION ALL SELECT 'raw_kaggle.Rk', COUNT(Rk), MIN(Rk), MAX(Rk), AVG(Rk), MEDIAN(Rk), STDDEV(Rk), QUANTILE_CONT(Rk,0.25), QUANTILE_CONT(Rk,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.vRk', COUNT(vRk), MIN(vRk), MAX(vRk), AVG(vRk), MEDIAN(vRk), STDDEV(vRk), QUANTILE_CONT(vRk,0.25), QUANTILE_CONT(vRk,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.TP', COUNT(TP), MIN(TP), MAX(TP), AVG(TP), MEDIAN(TP), STDDEV(TP), QUANTILE_CONT(TP,0.25), QUANTILE_CONT(TP,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.Aces', COUNT(Aces), MIN(Aces), MAX(Aces), AVG(Aces), MEDIAN(Aces), STDDEV(Aces), QUANTILE_CONT(Aces,0.25), QUANTILE_CONT(Aces,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.DFs', COUNT(DFs), MIN(DFs), MAX(DFs), AVG(DFs), MEDIAN(DFs), STDDEV(DFs), QUANTILE_CONT(DFs,0.25), QUANTILE_CONT(DFs,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.SP', COUNT(SP), MIN(SP), MAX(SP), AVG(SP), MEDIAN(SP), STDDEV(SP), QUANTILE_CONT(SP,0.25), QUANTILE_CONT(SP,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.1SP', COUNT(\"1SP\"), MIN(\"1SP\"), MAX(\"1SP\"), AVG(\"1SP\"), MEDIAN(\"1SP\"), STDDEV(\"1SP\"), QUANTILE_CONT(\"1SP\",0.25), QUANTILE_CONT(\"1SP\",0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.2SP', COUNT(\"2SP\"), MIN(\"2SP\"), MAX(\"2SP\"), AVG(\"2SP\"), MEDIAN(\"2SP\"), STDDEV(\"2SP\"), QUANTILE_CONT(\"2SP\",0.25), QUANTILE_CONT(\"2SP\",0.75) FROM raw.raw_kaggle UNION ALL SELECT 'raw_kaggle.vA', COUNT(vA), MIN(vA), MAX(vA), AVG(vA), MEDIAN(vA), STDDEV(vA), QUANTILE_CONT(vA,0.25), QUANTILE_CONT(vA,0.75) FROM raw.raw_kaggle UNION ALL SELECT 'return_kaggle.Rk', COUNT(Rk), MIN(Rk), MAX(Rk), AVG(Rk), MEDIAN(Rk), STDDEV(Rk), QUANTILE_CONT(Rk,0.25), QUANTILE_CONT(Rk,0.75) FROM raw.return_kaggle UNION ALL SELECT 'return_kaggle.vRk', COUNT(vRk), MIN(vRk), MAX(vRk), AVG(vRk), MEDIAN(vRk), STDDEV(vRk), QUANTILE_CONT(vRk,0.25), QUANTILE_CONT(vRk,0.75) FROM raw.return_kaggle UNION ALL SELECT 'serve_kaggle.Rk', COUNT(Rk), MIN(Rk), MAX(Rk), AVG(Rk), MEDIAN(Rk), STDDEV(Rk), QUANTILE_CONT(Rk,0.25), QUANTILE_CONT(Rk,0.75) FROM raw.serve_kaggle UNION ALL SELECT 'serve_kaggle.vRk', COUNT(vRk), MIN(vRk), MAX(vRk), AVG(vRk), MEDIAN(vRk), STDDEV(vRk), QUANTILE_CONT(vRk,0.25), QUANTILE_CONT(vRk,0.75) FROM raw.serve_kaggle"}</parameter> </invoke>