0

Please login or register to vote for this query.

(click on this box to dismiss)

Users active in the last three months with reputation over 500 who have voted less than per day (overall) than average of other users with reputation over 500.

Q&A for scientific skepticism

-- Active Users with Low Participation in Voting
-- Users active in the last three months with reputation over 500 who have voted less than per day (overall) than average of other users with reputation over 500.

select top 1000
  id as [User Link],
  Reputation as Rep, 
  UpVotes + DownVotes as "Votes",
  UpVotes as "Up",
  DownVotes as "Down",
  (UpVotes + DownVotes) / datediff(day,CreationDate,(SELECT MAX(LastActivityDate) FROM Posts))           as "Per Day"
from Users
where Reputation > 500
  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 > 500 and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 3))
order by Votes asc

fork query

created apr 1 11 mattdm