Q&A for professional and enthusiast programmers
SELECT CreationDate , Score , avg(CAST(Score AS FLOAT)) OVER ( ORDER BY CreationDate ROWS ##IncludePreceding:INT?9## PRECEDING ) AS RollingAvg FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = ##UserId:INT##;