Вопросы и ответы о сайте для программистов
WITH Raw AS ( SELECT DATEADD(dd, 7 * FLOOR(DATEDIFF(day, '1970-01-05', CreationDate) / 7), '1970-01-05') AS PostWeek, Id FROM Posts ) SELECT PostWeek, COUNT(*) AS Count FROM Raw GROUP BY PostWeek ORDER BY PostWeek;