<invoke name="query_sql"> <parameter name="purpose">Distribution summary for numeric columns: Sr No (BIGINT) and Amount in USD (VARCHAR cast to number)</parameter> <parameter name="sql">WITH a AS (SELECT "Sr No" AS sr, TRY_CAST(REPLACE("Amount in USD", ',', '') AS DOUBLE) AS amt, "Amount in USD" AS raw_amt FROM raw.startup_funding) SELECT 'Sr No' AS column_name, COUNT(*) AS n_rows, COUNT(sr) AS n_numeric, MIN(sr) AS min_v, MAX(sr) AS max_v, AVG(sr) AS mean_v, MEDIAN(sr) AS median_v, STDDEV(sr) AS stddev_v, QUANTILE_CONT(sr,0.25) AS p25, QUANTILE_CONT(sr,0.75) AS p75, QUANTILE_CONT(sr,0.95) AS p95 FROM a UNION ALL SELECT 'Amount in USD', COUNT(*), COUNT(amt), MIN(amt), MAX(amt), AVG(amt), MEDIAN(amt), STDDEV(amt), QUANTILE_CONT(amt,0.25), QUANTILE_CONT(amt,0.75), QUANTILE_CONT(amt,0.95) FROM a</parameter> <parameter name="source">raw</parameter> </invoke>