{
    "action": "tool_call",
    "reasoning": "Get monthly deal counts and funding totals to see the timeline of funding activity. Date is VARCHAR dd/mm/yyyy and may contain stray characters; Amount is VARCHAR with commas. Parse safely with TRY functions.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH t AS (SELECT try_strptime(regexp_replace(trim(\"Date dd/mm/yyyy\"), '[^0-9/]', '', 'g'), '%d/%m/%Y') AS d, TRY_CAST(regexp_replace(\"Amount in USD\", '[^0-9.]', '', 'g') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT strftime(date_trunc('month', d), '%Y-%m') AS month, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, ROUND(SUM(amt)/1e6,1) AS total_usd_m, ROUND(MEDIAN(amt)/1e6,2) AS median_usd_m FROM t GROUP BY 1 ORDER BY 1",
        "purpose": "Monthly deal count and funding amount to find spikes/dips/breaks",
        "source": "raw"
    }
}