A breakdown of the total votes cast on a site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges Meta

Q&A about the site for programming puzzle enthusiasts and code golfers

SELECT 
CASE

  WHEN VoteTypeId =  1 THEN 'Accepted Answer'
  WHEN VoteTypeId =  2 THEN 'Upvotes'
  WHEN VoteTypeId =  3 THEN 'Downvotes'
  WHEN VoteTypeId =  4 THEN 'Offensive Flags'
  WHEN VoteTypeId =  5 THEN 'Favorites'
  WHEN VoteTypeId =  6 THEN 'Close Votes cast before 2013-06-25'
  WHEN VoteTypeId =  7 THEN 'Reopen Votes'
  WHEN VoteTypeId =  8 THEN 'Bounties Started'
  WHEN VoteTypeId = 10 THEN 'Delete Votes'
  WHEN VoteTypeId = 11 THEN 'Undelete Votes'
  WHEN VoteTypeId = 12 THEN 'Spam Flags'
  WHEN VoteTypeId = 15 THEN 'Moderator Handling Flag'
  WHEN VoteTypeId = 16 THEN 'Approved Suggested Edit Review'
  
END AS [Vote Type],
COUNT(VoteTypeId) AS [Total Vote Count]

FROM Votes
WHERE VoteTypeId <> 9

GROUP BY VoteTypeId
ORDER BY [Total Vote Count] DESC

Enter Parameters

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