<invoke name="tool_call"> <parameter name="reasoning">Re-ground the missing-value counts with a single query over all five tables, treating NULL, blank and '[]' as missing, with per-month breakdown.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH allm AS (SELECT 'Jan' AS m, \"Company Name\" AS cn, CAST(\"Founded\" AS VARCHAR) AS fo, \"Location\" AS lo, \"Sector\" AS se, \"What it does\" AS wd, \"Founders\" AS fd, \"Investor\" AS inv, \"Amount\" AS am, \"Stage\" AS st FROM raw.\"Indian Startups _ Funding Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", CAST(\"Founded\" AS VARCHAR), \"Location\", \"Sector\", \"What it does\", \"Founders\", \"Investor\", \"Amount\", \"Stage\" FROM raw.\"Indian Startups _ Funding Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", CAST(\"Founded\" AS VARCHAR), \"Location\", \"Sector\", \"What it does\", \"Founders\", \"Investor\", \"Amount\", \"Stage\" FROM raw.\"Indian Startups _ Funding Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", CAST(\"Founded\" AS VARCHAR), \"Location\", \"Sector\", \"What it does\", \"Founders\", \"Investor\", \"Amount\", \"Stage\" FROM raw.\"Indian Startups _ Funding Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", CAST(\"Founded\" AS VARCHAR), \"Location\", \"Sector\", \"What it does\", \"Founders\", \"Investor\", \"Amount\", \"Stage\" FROM raw.\"Indian Startups _ Funding Investors Data May 2022\") SELECT m, COUNT(*) AS total_rows, SUM(CASE WHEN cn IS NULL OR TRIM(cn) IN ('','[]') THEN 1 ELSE 0 END) AS company_missing, SUM(CASE WHEN fo IS NULL OR TRIM(fo) IN ('','[]') THEN 1 ELSE 0 END) AS founded_missing, SUM(CASE WHEN lo IS NULL OR TRIM(lo) IN ('','[]') THEN 1 ELSE 0 END) AS location_missing, SUM(CASE WHEN se IS NULL OR TRIM(se) IN ('','[]') THEN 1 ELSE 0 END) AS sector_missing, SUM(CASE WHEN wd IS NULL OR TRIM(wd) IN ('','[]') THEN 1 ELSE 0 END) AS what_missing, SUM(CASE WHEN fd IS NULL OR TRIM(fd) IN ('','[]') THEN 1 ELSE 0 END) AS founders_missing, SUM(CASE WHEN inv IS NULL OR TRIM(inv) IN ('','[]') THEN 1 ELSE 0 END) AS investor_missing, SUM(CASE WHEN am IS NULL OR TRIM(am) IN ('','[]') THEN 1 ELSE 0 END) AS amount_missing, SUM(CASE WHEN st IS NULL OR TRIM(st) IN ('','[]') THEN 1 ELSE 0 END) AS stage_missing FROM allm GROUP BY m ORDER BY CASE m WHEN 'Jan' THEN 1 WHEN 'Feb' THEN 2 WHEN 'Mar' THEN 3 WHEN 'Apr' THEN 4 ELSE 5 END","purpose":"Missing-value counts (NULL, blank, '[]') per column per month across all five tables","source":"raw"}</parameter> </invoke>