Q&A for professional and enthusiast programmers
;with counts_cte AS (SELECT eomonth(p.CreationDate) AS Cmonth, SUM(Score) AS Score, SUM(ViewCount) AS Views FROM Posts p WHERE PostTypeId=1 GROUP BY eomonth(p.CreationDate) ) SELECT Cmonth, 100*(CAST(Score AS decimal))/(CAST(Views AS decimal)) AS [Score per view] FROM counts_cte ORDER BY Cmonth