Top 100 Most Frequent Voters

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users based on the number of votes cast per day

Stack Overflow

Q&A for professional and enthusiast programmers

-- Top 100 Most Frequent Voters
-- The top 100 users based on the number of votes cast per day

DECLARE @lastDataUpdate DATETIME
SELECT @lastDataUpdate = MAX(CreationDate) FROM Posts

SELECT TOP 300
 U.Id AS [User Link],
 U.UpVotes,
 U.DownVotes,
 (U.UpVotes + U.DownVotes) AS TotalVotes,
 ( 1000/(U.UpVotes + U.DownVotes +1 ) ) AS VotesRatio

FROM
 Users U

ORDER BY
  TotalVotes DESC

Enter Parameters

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