SQL moving average

SQL moving average.sql

WITH   cte
AS     (SELECT 
			1 AS n -- anchor member
			,Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float) AS rnd
        UNION ALL
        SELECT 
			n + 1 -- recursive member
			,Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float)
        FROM   cte
        WHERE  n < 50 -- terminator
       )
SELECT 
	n
	,rnd
	,AVG(rnd) OVER(ORDER BY n ASC ROWS 2 PRECEDING) AS MA3
FROM   cte;