{
    "action": "tool_call",
    "reasoning": "Amount in USD is VARCHAR and needs cleaning; Industry Vertical is the main classifier. Compute deal count, total, average and median funding per vertical for the top 15 by total.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH c AS (SELECT TRIM(\"Industry Vertical\") AS vertical, TRY_CAST(REPLACE(REPLACE(\"Amount in USD\", ',', ''), ' ', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT vertical, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, ROUND(SUM(amt)/1e6,1) AS total_usd_m, ROUND(AVG(amt)/1e6,2) AS avg_usd_m, ROUND(MEDIAN(amt)/1e6,2) AS median_usd_m FROM c WHERE vertical IS NOT NULL AND vertical <> '' GROUP BY vertical HAVING COUNT(amt) > 0 ORDER BY total_usd_m DESC LIMIT 15",
        "purpose": "Funding amount by industry vertical (top 15 by total)",
        "source": "raw"
    }
}