<invoke name="query_sql"> <parameter name="sql">WITH u AS ( SELECT "Founded" AS f, "Amount" AS a FROM raw."Indian Startups _ Funding Investors Data January 2022" UNION ALL SELECT "Founded", "Amount" FROM raw."Indian Startups _ Funding Investors Data February 2022" UNION ALL SELECT "Founded", "Amount" FROM raw."Indian Startups _ Funding Investors Data March 2022" UNION ALL SELECT "Founded", "Amount" FROM raw."Indian Startups _ Funding Investors Data April 2022" UNION ALL SELECT TRY_CAST("Founded" AS BIGINT), "Amount" FROM raw."Indian Startups _ Funding Investors Data May 2022" ), p AS ( SELECT f, TRY_CAST(REPLACE(REPLACE(a, '$', ''), ',', '') AS DOUBLE) AS amt FROM u ) SELECT COUNT(*) AS total_rows, COUNT(f) AS founded_valid, MIN(f) AS founded_min, quantile_cont(f, 0.25) AS founded_p25, MEDIAN(f) AS founded_median, AVG(f) AS founded_mean, quantile_cont(f, 0.75) AS founded_p75, MAX(f) AS founded_max, STDDEV(f) AS founded_sd, COUNT(amt) AS amount_valid, MIN(amt) AS amount_min, quantile_cont(amt, 0.25) AS amount_p25, MEDIAN(amt) AS amount_median, AVG(amt) AS amount_mean, quantile_cont(amt, 0.75) AS amount_p75, MAX(amt) AS amount_max, STDDEV(amt) AS amount_sd FROM p</parameter> <parameter name="purpose">Pooled descriptive statistics for Founded and Amount across all five monthly tables</parameter> <parameter name="source">raw</parameter> </invoke> </parameter> </invoke>