1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

SELECT p.OwnerUserId AS [User Link], COUNT(1) AS 'Total Upvotes On Questions', COUNT(1) * 5 AS 'Estimated Rep Gain'
  FROM Posts p 
    INNER JOIN Votes v ON p.Id = v.PostId
  WHERE p.PostTypeId = 1 -- Question
    AND v.VoteTypeId = 2 -- UpMod aka upvotes
    GROUP BY p.OwnerUserId
    ORDER BY 3 DESC

fork query

edited nov 13 Miniman

created nov 13 Mage Xy