<invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT year(try_strptime(trim("Date dd/mm/yyyy"), '%d/%m/%Y')) AS yr, try_cast(replace(trim("Amount in USD"), ',', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT yr, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, MEDIAN(amt) AS median_amount_usd, SUM(amt) AS total_amount_usd FROM t GROUP BY yr ORDER BY yr</parameter> <parameter name="purpose">Yearly deal count, disclosed-amount coverage, median ticket and total to assess whether funding is accelerating or slowing</parameter> <parameter name="source">raw</parameter> </invoke>