Q&A for professional mathematicians
SELECT CAST(CreationDate as Date), COUNT(DISTINCT RevisionGUID) FROM PostHistory WHERE ((PostHistoryTypeId in (4,5,6)) AND (UserId=##userid##)) GROUP BY CAST(CreationDate as Date) ORDER BY CAST(CreationDate as Date) DESC