<invoke name="tool_call"> <parameter name="reasoning">No evidence is available in this turn, so I must re-ground the data-quality answer. First profile Amount formats per month with one UNION query.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH u AS (SELECT 'Jan' AS m, \"Company Name\" AS c, Amount AS a, Founded::VARCHAR AS f FROM raw.\"Indian Startups _ Funding Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", Amount, Founded::VARCHAR FROM raw.\"Indian Startups _ Funding Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", Amount, Founded::VARCHAR FROM raw.\"Indian Startups _ Funding Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", Amount, Founded::VARCHAR FROM raw.\"Indian Startups _ Funding Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Amount, Founded FROM raw.\"Indian Startups _ Funding Investors Data May 2022\") SELECT m, COUNT(*) AS total_rows, COUNT(*) FILTER (WHERE regexp_matches(a, '^\\$[0-9]{1,3}(,[0-9]{3})*$')) AS clean_dollar, COUNT(*) FILTER (WHERE lower(a) = 'undisclosed') AS undisclosed, COUNT(*) FILTER (WHERE a IS NULL OR trim(a) = '') AS blank, COUNT(*) FILTER (WHERE a IS NOT NULL AND trim(a) <> '' AND lower(a) <> 'undisclosed' AND NOT regexp_matches(a, '^\\$[0-9]{1,3}(,[0-9]{3})*$')) AS other_format, COUNT(*) FILTER (WHERE c IS NULL OR trim(c) = '') AS blank_company, COUNT(*) - COUNT(DISTINCT c) AS dup_company_rows FROM u GROUP BY m ORDER BY m","purpose":"Profile Amount format cleanliness, blanks and duplicate companies per month","source":"raw"}</parameter> </invoke>