Shows you how many times you approved and the edit got approved, you rejected but the edit got approved, you approved but the edit got rejected, and you rejected and the edit got rejected.
Q&A for professional and enthusiast programmers
COUNT(*) AS [Count],
CASE WHEN VoteTypeId = 3 THEN 'Rejected' WHEN VoteTypeId = 2 THEN 'Approved' ELSE 'Edited/other' END AS 'You...',
CASE WHEN ApprovalDate IS NULL THEN 'Rejected' ELSE 'Approved' END AS 'They...'
INNER JOIN SuggestedEdits ON SuggestedEdits.Id = SuggestedEditVotes.SuggestedEditId
SuggestedEditVotes.UserId = ##UserId##
CASE WHEN ApprovalDate IS NULL THEN 'Rejected' ELSE 'Approved' END