Voting stats

2

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select
   id as [User Link]
  , CreationDate
  , LastAccessDate
  , UpVotes
  , DownVotes
  , UpVotes + DownVotes As TotalVotes
  , Upvotes * 1.0 / (UpVotes + DownVotes) As UpVotePercent
  , (UpVotes + DownVotes) * 1.0 / DateDiff(Day, CreationDate, LastAccessDate) As VotesPerDay
from users u
where upvotes + downvotes > ##Threshold## and DateDiff(Day, CreationDate, LastAccessDate) > 0
order by Upvotes + Downvotes desc

Enter Parameters

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