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

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(Downvotes) from Users) as "All Total Votes"
from Users
where Reputation > 200
  and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 3
order by LastAccessDate desc 

fork query

created apr 1 11 mattdm