Active Users with Low Participation in Voting

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 have voted less than

Skeptics

Q&A for scientific skepticism

-- Active Users with Low Participation in Voting
-- All users active in the last three months who have voted less than 

select top 1000
  id as [User Link],
  Reputation as Rep, 
  UpVotes + DownVotes as "Votes",
  UpVotes as "Up",
  DownVotes as "Down"
from Users
where Reputation > 200
  and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 3
  and (UpVotes + DownVotes) < ((SELECT sum(UpVotes+DownVotes) from Users) / (SELECT count(*) from Users where Reputation > 200 and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 3))
order by Votes desc 

Enter Parameters

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