Moving Averages / MS SQL 2012

gistfile1.sql

-- Cumulative Moving Average (CMA) and Simple Moving Average (SMA)
SELECT
	d.Value,
	AVG(d.Value) OVER (PARTITION BY d.MetricId ORDER BY d.Id) AS 'CMA',
	AVG(d.Value) OVER (PARTITION BY d.MetricId ORDER BY d.Id ROWS 2 PRECEDING) AS 'SMA(3)',
	AVG(d.Value) OVER (PARTITION BY d.MetricId ORDER BY d.Id ROWS 6 PRECEDING) AS 'SMA(7)'
FROM DailyTotals AS d
WHERE
	d.DateId >= '20150101'
AND d.MetricId = 2;