<invoke name="query_sql"> <parameter name="purpose">Highest and lowest funding deals by cleaned Amount in USD</parameter> <parameter name="sql">WITH c AS (SELECT "Sr No" AS sr_no, "Date dd/mm/yyyy" AS deal_date, "Startup Name" AS startup, "Industry Vertical" AS vertical, "City Location" AS city, "InvestmentnType" AS round_type, "Amount in USD" AS raw_amount, TRY_CAST(REPLACE(REPLACE(TRIM("Amount in USD"), ',', ''), '+', '') AS DOUBLE) AS amount_usd FROM raw.startup_funding), v AS (SELECT * FROM c WHERE amount_usd IS NOT NULL), hi AS (SELECT 'highest' AS side, * FROM v ORDER BY amount_usd DESC LIMIT 5), lo AS (SELECT 'lowest' AS side, * FROM v ORDER BY amount_usd ASC LIMIT 5) SELECT * FROM hi UNION ALL SELECT * FROM lo</parameter> <parameter name="source">raw</parameter> </invoke>