<invoke name="tool_call"> <parameter name="reasoning">Compute null/blank counts and percentages for every source column in one query, in long format.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="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/total,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) m, n ORDER BY missing DESC","purpose":"Missing (NULL or blank) count and percent per source column","source":"raw"}</parameter> </invoke>