<invoke name="tool_call"> <parameter name="reasoning">Inspect the amount outliers (max was nan), non-standard date formats, and duplicate deals in one pass.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH c AS (SELECT \"Sr No\" sr, \"Startup Name\" nm, \"Date dd/mm/yyyy\" d, \"Amount in USD\" a, TRY_CAST(REPLACE(REPLACE(REPLACE(\"Amount in USD\",',',''),'\\xc2\\xa0',''),'+','') AS DOUBLE) v FROM raw.startup_funding) SELECT 'top_amount' k, nm, d, a, v FROM (SELECT * FROM c WHERE v IS NOT NULL ORDER BY v DESC LIMIT 6) UNION ALL SELECT 'nan_or_inf', nm, d, a, v FROM (SELECT * FROM c WHERE isnan(v) OR isinf(v) LIMIT 3) UNION ALL SELECT 'bad_date', nm, d, a, v FROM (SELECT * FROM c WHERE NOT regexp_matches(d,'^[0-9]{2}/[0-9]{2}/[0-9]{4}$') LIMIT 12) UNION ALL SELECT 'small_amount', nm, d, a, v FROM (SELECT * FROM c WHERE v IS NOT NULL AND v < 10000 ORDER BY v LIMIT 5)","purpose":"Find outliers, nan values, malformed dates, tiny amounts","source":"raw"}</parameter> </invoke>