Top 100 users having highest votes per day ratio


Please login or register to vote for this query.

(click on this box to dismiss)

Lists top 100 users who have highest votes/day ratio excluding community user and minimum of 100 votes cast. Uncomment last line to filter by id.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description
select top 100
     id [User Link]
     , datediff(dd, creationdate, GETDATE() )"Days"
     ,(upvotes+downvotes) "Votes"
     , round(cast(nullif((upvotes+downvotes), 0)as float) / datediff(dd, creationdate, GETDATE()),4)  "Votes/Day Ratio"
from users
where  id <> -1
and  (upvotes+downvotes)> 100
-- and id = ##User_ID##
order by "Votes/Day Ratio" desc

Enter Parameters

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