<invoke name="query_sql"> <parameter name="sql">WITH u AS ( SELECT 'January' AS tbl, * FROM (SELECT "Company Name" cn, CAST(Founded AS VARCHAR) fo, Location lo, Sector se, "What it does" wi, Founders fd, Investor iv, Amount am, Stage st FROM raw."Indian Startups _ Funding Investors Data January 2022") UNION ALL SELECT 'February', * FROM (SELECT "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', * FROM (SELECT "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', * FROM (SELECT "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', * FROM (SELECT "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(*) n, ROUND(100.0*COUNT_IF(cn IS NULL)/COUNT(*),1) pct_company, ROUND(100.0*COUNT_IF(fo IS NULL)/COUNT(*),1) pct_founded, ROUND(100.0*COUNT_IF(lo IS NULL)/COUNT(*),1) pct_location, ROUND(100.0*COUNT_IF(se IS NULL)/COUNT(*),1) pct_sector, ROUND(100.0*COUNT_IF(wi IS NULL)/COUNT(*),1) pct_what_it_does, ROUND(100.0*COUNT_IF(fd IS NULL)/COUNT(*),1) pct_founders, ROUND(100.0*COUNT_IF(iv IS NULL)/COUNT(*),1) pct_investor, ROUND(100.0*COUNT_IF(am IS NULL)/COUNT(*),1) pct_amount, ROUND(100.0*COUNT_IF(st IS NULL)/COUNT(*),1) pct_stage FROM u GROUP BY tbl</parameter> <parameter name="purpose">Compute percent missing per column per monthly table</parameter> </invoke>