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.


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

-- Enter Query Title
-- Enter Query Description
select top 1000
     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 = 945456
order by "Votes/Day Ratio" desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results