<invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT regexp_extract("Date dd/mm/yyyy", '(\d{4})', 1) AS yr, TRY_CAST(REPLACE("Amount in USD", ',', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT yr, COUNT(*) AS deals, COUNT(CASE WHEN amt IS NOT NULL AND isfinite(amt) THEN 1 END) AS disclosed_deals, MEDIAN(CASE WHEN isfinite(amt) THEN amt END) AS median_usd, SUM(CASE WHEN isfinite(amt) THEN amt END) AS total_usd FROM t GROUP BY yr ORDER BY yr</parameter> <parameter name="purpose">Verify yearly deal count, disclosed count, median ticket and total funding to assess acceleration/slowing</parameter> <parameter name="source">raw</parameter> </invoke> </tool_call> <br> Wait, I must output only JSON.