<invoke name="query_sql"> <parameter name="sql">WITH a AS (SELECT "Startup Name" AS startup, "Date dd/mm/yyyy" AS dt, "InvestmentnType" AS rnd, TRY_CAST(REPLACE(REPLACE("Amount in USD", ',', ''), '+', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT COUNT(*) AS total_rows, COUNT(amt) AS parsed_amounts, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd, COUNT(*) FILTER (WHERE amt >= 100000000) AS deals_100m_plus, SUM(amt) FILTER (WHERE amt >= 100000000) / SUM(amt) AS share_of_total_from_100m_plus, MAX(amt) AS max_usd, MAX_BY(startup, amt) AS max_startup, MAX_BY(dt, amt) AS max_date, MAX_BY(rnd, amt) AS max_round, MAX(amt) / SUM(amt) AS max_share FROM a</parameter> <parameter name="purpose">Verify headline concentration stats and the largest deal</parameter> <parameter name="source">raw</parameter> </invoke>