0

Please login or register to vote for this query.

(click on this box to dismiss)

All users active in the last three months who.

Q&A for scientific skepticism

-- Active Users with Low Participation in Voting
-- All users active in the last three months who.

select top 1000
  Round(((((UpVotes + DownVotes) / (Reputation/10.0)) * 100.0) - 100), 0) as [Index Rank],
  Reputation as Rep, 
  UpVotes as [+ Votes],
  DownVotes [- Votes],
  (SELECT MAX(LastActivityDate) FROM Posts) as "LastDB"
from Users
where Reputation > 200
  and LastAccessDate > 0
order by Round(((((UpVotes + DownVotes) / (Reputation/10.0)) * 100.0) - 100), 3) desc

fork query

created apr 1 11 mattdm