Q&A for science fiction and fantasy enthusiasts
SELECT Users.Id as [User Link], CONVERT(char(7), Votes.CreationDate, 102) as LeMonth, COUNT(*) Downvotes FROM ( SELECT DISTINCT Votes.PostId, Votes.CreationDate FROM Votes WHERE Votes.VoteTypeId = 3 ) Votes INNER JOIN Posts ON Votes.PostId = Posts.Id INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Users.DisplayName = '##username##' GROUP BY Users.Id, CONVERT(char(7), Votes.CreationDate, 102) ORDER BY LeMonth, Downvotes DESC