<invoke name="query_sql"> <parameter name="sql">WITH u AS ( SELECT "Company Name" c, TRY_CAST(Founded AS BIGINT) f, Location l, Sector s, Stage st, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) a FROM raw."Indian Startups _ Funding Investors Data January 2022" UNION ALL SELECT "Company Name", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw."Indian Startups _ Funding Investors Data February 2022" UNION ALL SELECT "Company Name", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw."Indian Startups _ Funding Investors Data March 2022" UNION ALL SELECT "Company Name", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw."Indian Startups _ Funding Investors Data April 2022" UNION ALL SELECT "Company Name", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw."Indian Startups _ Funding Investors Data May 2022" ) SELECT st AS stage, COUNT(*) n, COUNT(a) n_with_amount, ROUND(MEDIAN(a)) median_amount, ROUND(AVG(f)) avg_founded, ROUND(CORR(f, LN(a)),3) corr_founded_logamt FROM u WHERE st IS NOT NULL AND st <> '' GROUP BY st HAVING COUNT(*) >= 5 ORDER BY median_amount DESC NULLS LAST</parameter> <parameter name="purpose">Relate Stage to Amount and Founded across all months (stage vs. amount relationship)</parameter> </invoke>