Q&A for scientists using computers to solve scientific problems
SELECT DATEFROMPARTS( DATEPART(yyyy, CreationDate), DATEPART(mm, CreationDate), 1) AS Month, COUNT(*) AS Count FROM Posts WHERE Id IN ( SELECT MIN(Id) AS Id FROM Posts WHERE OwnerUserId > 0 GROUP BY OwnerUserId ) GROUP BY DATEFROMPARTS( DATEPART(yyyy, CreationDate), DATEPART(mm, CreationDate), 1) ORDER BY Month DESC;