<invoke name="query_sql"> <parameter name="sql">WITH c AS (SELECT TRY_CAST(REPLACE(REGEXP_REPLACE("Amount in USD", '[^0-9,.]', '', 'g'), ',', '') AS DOUBLE) AS amt, TRY_STRPTIME(REGEXP_REPLACE("Date dd/mm/yyyy", '[^0-9/]', '', 'g'), '%d/%m/%Y') AS d FROM raw.startup_funding) SELECT date_trunc('quarter', d) AS quarter, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd FROM c GROUP BY 1 ORDER BY 1</parameter> <parameter name="purpose">Quarterly deal counts and funding amounts to assess whether funding activity is accelerating or slowing</parameter> <parameter name="source">raw</parameter> </invoke> </action> </parameter> </invoke>