{
    "action": "tool_call",
    "reasoning": "No query results are in my evidence yet, so I can't rely on the figures in my earlier text. I'll parse the VARCHAR amount (strip commas) and pull the top and bottom deals so the numbers come from an actual result.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH p AS (SELECT \"Sr No\" AS sr_no, \"Date dd/mm/yyyy\" AS deal_date, \"Startup Name\" AS startup, \"Industry Vertical\" AS vertical, \"City  Location\" AS city, \"InvestmentnType\" AS round_type, TRY_CAST(REPLACE(REPLACE(\"Amount in USD\", ',', ''), ' ', '') AS DOUBLE) AS amount_usd FROM raw.startup_funding), r AS (SELECT *, ROW_NUMBER() OVER (ORDER BY amount_usd DESC) AS rn_desc, ROW_NUMBER() OVER (ORDER BY amount_usd ASC) AS rn_asc FROM p WHERE amount_usd IS NOT NULL) SELECT sr_no, deal_date, startup, vertical, city, round_type, amount_usd, CASE WHEN rn_desc <= 8 THEN 'top' ELSE 'bottom' END AS side FROM r WHERE rn_desc <= 8 OR rn_asc <= 8 ORDER BY amount_usd DESC",
        "purpose": "Highest and lowest parsed funding amounts, excluding unparseable or missing values",
        "source": "raw"
    }
}