It shows the stats only until the last completely dumped month to the SEDE.
Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
DECLARE @TsNow DATETIME; SELECT @TsNow = DATEFROMPARTS( DATEPART(yyyy, MAX(CreationDate)), DATEPART(mm, MAX(CreationDate)), 1) FROM Posts; SELECT DATEFROMPARTS( DATEPART(yyyy, CreationDate), DATEPART(mm, CreationDate), 1) AS Month, COUNT(DeletionDate) AS Deleted, COUNT(CASE WHEN ClosedDate IS NOT NULL THEN 1 ELSE NULL END) AS ClosedOrDeleted, COUNT(*) AS AllQuestions FROM PostsWithDeleted WHERE PostTypeId=1 AND CreationDate < @TsNow GROUP BY DATEFROMPARTS( DATEPART(yyyy, CreationDate), DATEPART(mm, CreationDate), 1) ORDER BY Month