{
    "action": "tool_call",
    "reasoning": "Profile missing-value rates per column across all five monthly tables in one query, casting Founded to VARCHAR so the tables can be unioned.",
    "tool": "query_sql",
    "args": {
        "source": "raw",
        "purpose": "Per-month row counts and null percentages for each key column",
        "sql": "WITH u AS (SELECT 'January' AS tbl, \"Company Name\" AS cn, CAST(Founded AS VARCHAR) AS fo, Location AS lo, Sector AS se, \"What it does\" AS wi, Founders AS fd, Investor AS iv, Amount AS am, Stage AS st FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'February', \"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 'March', \"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 'April', \"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 tbl, COUNT(*) AS n, ROUND(100.0*COUNT_IF(cn IS NULL)/COUNT(*),1) AS pct_company, ROUND(100.0*COUNT_IF(fo IS NULL)/COUNT(*),1) AS pct_founded, ROUND(100.0*COUNT_IF(lo IS NULL)/COUNT(*),1) AS pct_location, ROUND(100.0*COUNT_IF(se IS NULL)/COUNT(*),1) AS pct_sector, ROUND(100.0*COUNT_IF(wi IS NULL)/COUNT(*),1) AS pct_what_it_does, ROUND(100.0*COUNT_IF(fd IS NULL)/COUNT(*),1) AS pct_founders, ROUND(100.0*COUNT_IF(iv IS NULL)/COUNT(*),1) AS pct_investor, ROUND(100.0*COUNT_IF(am IS NULL)/COUNT(*),1) AS pct_amount, ROUND(100.0*COUNT_IF(st IS NULL)/COUNT(*),1) AS pct_stage FROM u GROUP BY tbl ORDER BY CASE tbl WHEN 'January' THEN 1 WHEN 'February' THEN 2 WHEN 'March' THEN 3 WHEN 'April' THEN 4 ELSE 5 END"
    }
}