<invoke name="tool_call"> <parameter name="reasoning">Date is VARCHAR with some dirty values; extract d/m/y via regex and aggregate monthly deal count and disclosed amount.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql": "WITH p AS (SELECT try_cast(regexp_extract(\"Date dd/mm/yyyy\", '(\\d{1,2})/(\\d{1,2})/(\\d{4})', 3) AS INT) AS y, try_cast(regexp_extract(\"Date dd/mm/yyyy\", '(\\d{1,2})/(\\d{1,2})/(\\d{4})', 2) AS INT) AS m, try_cast(replace(\"Amount in USD\", ',', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT make_date(y, m, 1) AS month, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd FROM p WHERE y IS NOT NULL AND m BETWEEN 1 AND 12 GROUP BY 1 ORDER BY 1", "purpose": "Monthly deal count and disclosed funding amount over time", "source": "raw"}</parameter> </invoke>