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",
  LastAccessDate as "Last Seen",
  (SELECT sum(UpVotes+DownVotes) from Users) as "All Total Votes",
  (SELECT count(*) from Users) as "User Count"
from Users
where Reputation > 200
  and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 3
order by LastAccessDate desc 

Enter Parameters

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