Monthly Reputation Change

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
	  COUNT(*),
	  Posts.OwnerUserId,
	  FORMAT ( Votes.CreationDate, 'yyyy/MM', 'en-US' ) as VoteMonth
	FROM Posts INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2
	WHERE 
    Posts.OwnerUserId in (##UserId##)
    and Posts.PostTypeId = 2     
	GROUP BY Posts.OwnerUserId, FORMAT ( Votes.CreationDate, 'yyyy/MM', 'en-US' )
	ORDER BY Posts.OwnerUserId, VoteMonth

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results