<invoke name="query_sql"> <parameter name="sql">WITH a AS ( SELECT 'Jan' m, "Company Name" c, Founded::VARCHAR f, Location l, Sector s, Amount amt, Stage st FROM raw."Indian Startups _ Funding Investors Data January 2022" UNION ALL SELECT 'Feb', "Company Name", Founded::VARCHAR, Location, Sector, Amount, Stage FROM raw."Indian Startups _ Funding Investors Data February 2022" UNION ALL SELECT 'Mar', "Company Name", Founded::VARCHAR, Location, Sector, Amount, Stage FROM raw."Indian Startups _ Funding Investors Data March 2022" UNION ALL SELECT 'Apr', "Company Name", Founded::VARCHAR, Location, Sector, Amount, Stage FROM raw."Indian Startups _ Funding Investors Data April 2022" UNION ALL SELECT 'May', "Company Name", Founded::VARCHAR, Location, Sector, Amount, Stage FROM raw."Indian Startups _ Funding Investors Data May 2022") SELECT m, COUNT(*) n, COUNT(c) has_company, COUNT(amt) has_amt, SUM(CASE WHEN amt LIKE '$%' THEN 1 ELSE 0 END) dollar_prefixed, SUM(CASE WHEN amt LIKE '₹%' OR amt LIKE '%INR%' OR amt LIKE '%Rs%' THEN 1 ELSE 0 END) rupee, SUM(CASE WHEN amt ILIKE '%undisclosed%' THEN 1 ELSE 0 END) undisclosed, SUM(CASE WHEN amt IN ('—','-','--','') THEN 1 ELSE 0 END) dash_blank, SUM(CASE WHEN amt LIKE '%,%' THEN 1 ELSE 0 END) with_commas, SUM(CASE WHEN amt NOT LIKE '$%' AND amt NOT ILIKE '%undisclosed%' AND amt IS NOT NULL THEN 1 ELSE 0 END) other_format, SUM(CASE WHEN f IS NULL THEN 1 ELSE 0 END) null_founded, SUM(CASE WHEN TRY_CAST(f AS INT) IS NULL AND f IS NOT NULL THEN 1 ELSE 0 END) nonnumeric_founded, SUM(CASE WHEN TRY_CAST(f AS INT) < 1950 OR TRY_CAST(f AS INT) > 2022 THEN 1 ELSE 0 END) odd_founded, COUNT(*) - COUNT(DISTINCT c) dup_company FROM a GROUP BY m ORDER BY m</parameter> <parameter name="purpose">Profile Amount formats, Founded validity, nulls and duplicates across all five monthly tables</parameter> </invoke> </tool_call> <invoke name="query_sql"> <parameter name="sql">SELECT 1</parameter> <parameter name="purpose">noop</parameter> </invoke>