<invoke name="tool_call"> <parameter name="reasoning">Start by finding concentration of funding: parse Amount (VARCHAR with commas) and look at the top deals and share of total, plus null rate.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql": "WITH a AS (SELECT \"Startup Name\" AS startup, \"Investors Name\" AS investors, \"InvestmentnType\" AS typ, \"Date dd/mm/yyyy\" AS d, TRY_CAST(REPLACE(REPLACE(\"Amount in USD\", ',', ''), '\\\\xc2\\\\xa0', '') AS DOUBLE) AS amt FROM raw.startup_funding), t AS (SELECT SUM(amt) AS total, COUNT(*) AS n, COUNT(amt) AS n_amt FROM a) SELECT startup, typ, d, amt, ROUND(100.0*amt/(SELECT total FROM t),2) AS pct_of_total, (SELECT n FROM t) AS rows_total, (SELECT n_amt FROM t) AS rows_with_amt, (SELECT total FROM t) AS total_usd FROM a WHERE amt IS NOT NULL ORDER BY amt DESC LIMIT 10", "purpose": "Top deals and their share of total disclosed funding; disclosure rate", "source": "raw"}</parameter> </invoke>