{
    "action": "tool_call",
    "reasoning": "Compute null/blank counts and percentages for every source column in one query, in long format.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH t AS (SELECT * FROM raw.startup_funding), n AS (SELECT COUNT(*) AS total FROM t) SELECT col, missing, ROUND(100.0*missing/(SELECT total FROM n),2) AS pct_missing FROM (SELECT 'Sr No' AS col, COUNT(*) FILTER (WHERE \"Sr No\" IS NULL) AS missing FROM t UNION ALL SELECT 'Date dd/mm/yyyy', COUNT(*) FILTER (WHERE \"Date dd/mm/yyyy\" IS NULL OR TRIM(\"Date dd/mm/yyyy\")='') FROM t UNION ALL SELECT 'Startup Name', COUNT(*) FILTER (WHERE \"Startup Name\" IS NULL OR TRIM(\"Startup Name\")='') FROM t UNION ALL SELECT 'Industry Vertical', COUNT(*) FILTER (WHERE \"Industry Vertical\" IS NULL OR TRIM(\"Industry Vertical\")='') FROM t UNION ALL SELECT 'SubVertical', COUNT(*) FILTER (WHERE \"SubVertical\" IS NULL OR TRIM(\"SubVertical\")='') FROM t UNION ALL SELECT 'City  Location', COUNT(*) FILTER (WHERE \"City  Location\" IS NULL OR TRIM(\"City  Location\")='') FROM t UNION ALL SELECT 'Investors Name', COUNT(*) FILTER (WHERE \"Investors Name\" IS NULL OR TRIM(\"Investors Name\")='') FROM t UNION ALL SELECT 'InvestmentnType', COUNT(*) FILTER (WHERE \"InvestmentnType\" IS NULL OR TRIM(\"InvestmentnType\")='') FROM t UNION ALL SELECT 'Amount in USD', COUNT(*) FILTER (WHERE \"Amount in USD\" IS NULL OR TRIM(\"Amount in USD\")='') FROM t UNION ALL SELECT 'Remarks', COUNT(*) FILTER (WHERE \"Remarks\" IS NULL OR TRIM(\"Remarks\")='') FROM t) ORDER BY missing DESC",
        "purpose": "Null/blank counts and percentages for each source column",
        "source": "raw"
    }
}