<invoke name="query_sql"> <parameter name="sql">SELECT 'YEAR' AS metric, COUNT(YEAR) AS n, MIN(YEAR) AS min_v, MAX(YEAR) AS max_v, AVG(YEAR) AS mean_v, MEDIAN(YEAR) AS median_v, STDDEV(YEAR) AS stddev_v, QUANTILE_CONT(YEAR, 0.25) AS p25, QUANTILE_CONT(YEAR, 0.75) AS p75, QUANTILE_CONT(YEAR, 0.99) AS p99 FROM raw.Website_Analytics</parameter> <parameter name="purpose">Complete the numeric profile with YEAR, the only numeric column not yet summarized</parameter> </invoke>