<invoke name="query_sql"> <parameter name="sql">SELECT EXTRACT(year FROM d) AS yr, COUNT(*) AS deals, MIN(d) AS first_date, MAX(d) AS last_date FROM (SELECT TRY_STRPTIME(REPLACE("Date dd/mm/yyyy", chr(160), ''), '%d/%m/%Y') AS d FROM raw.startup_funding) WHERE d IS NOT NULL GROUP BY 1 ORDER BY 1</parameter> <parameter name="purpose">Deals per year to find the real covered period and identify the anomalous 0015 year</parameter> </invoke> <parameter name="source">raw</parameter>