Most frequent voters, active in last year

1

Please login or register to vote for this query.

(click on this box to dismiss)

Modified from DMA57361's query (28276).

Stack Overflow

Q&A for professional and enthusiast programmers

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

SELECT TOP 200
 U.ID AS [User Link],
 U.UpVotes AS Upvotes,
 U.DownVotes AS Downvotes,
 (U.UpVotes + U.DownVotes) AS TotalVotes,
 ROUND(CAST((U.UpVotes + U.DownVotes) AS FLOAT) / (DateDiff(day,U.CreationDate,@lastDataUpdate)+1),2) AS DailyVotes

FROM
 Users U

WHERE
 DATEDIFF(day,U.LastAccessDate,GETDATE()) < 365 AND
 (U.UpVotes + U.DownVotes) >= 100

ORDER BY
  DailyVotes DESC

Enter Parameters

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