<invoke name="tool_call"> <parameter name="reasoning">Profile nulls, date format conformity, amount parseability, duplicates in one query.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"purpose":"Profile data quality: nulls, date formats, amount parseability","source":"raw","sql":"SELECT COUNT(*) AS n, COUNT(DISTINCT \"Sr No\") AS distinct_sr, COUNT(\"Date dd/mm/yyyy\") AS date_nonnull, SUM(CASE WHEN regexp_matches(\"Date dd/mm/yyyy\", '^[0-9]{2}/[0-9]{2}/[0-9]{4}$') THEN 1 ELSE 0 END) AS date_std, SUM(CASE WHEN \"Date dd/mm/yyyy\" LIKE '%.%' OR \"Date dd/mm/yyyy\" LIKE '%-%' THEN 1 ELSE 0 END) AS date_other_sep, COUNT(\"Amount in USD\") AS amt_nonnull, SUM(CASE WHEN TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE) IS NOT NULL THEN 1 ELSE 0 END) AS amt_numeric, SUM(CASE WHEN \"Amount in USD\" IS NOT NULL AND TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE) IS NULL THEN 1 ELSE 0 END) AS amt_nonnumeric, SUM(CASE WHEN TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE) <= 0 THEN 1 ELSE 0 END) AS amt_nonpos, MIN(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_min, MAX(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_max, MEDIAN(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_median, quantile_cont(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE), 0.99) AS amt_p99, COUNT(\"Startup Name\") AS name_nn, COUNT(\"Industry Vertical\") AS ind_nn, COUNT(\"SubVertical\") AS sub_nn, COUNT(\"City Location\") AS city_nn, COUNT(\"Investors Name\") AS inv_nn, COUNT(\"InvestmentnType\") AS type_nn, COUNT(\"Remarks\") AS remarks_nn FROM raw.startup_funding"}</parameter> </invoke>