Got most down to non-CW answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

SELECT TOP 100
  DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS Rank,
  Posts.OwnerUserId AS [User Link],
  Posts.OwnerUserId AS UserId,
  COUNT(*) AS Count
FROM Posts, Votes
WHERE
  Posts.Id = Votes.PostId
  AND
  Votes.VoteTypeId = 3
  AND
  Posts.PostTypeId = 2
  AND
  Posts.CommunityOwnedDate IS NULL
  AND
  Posts.OwnerUserId > 0
GROUP BY Posts.OwnerUserId
ORDER BY Count DESC, UserId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results