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 with fewer than 10 votes per day since joining the site.

Q&A for scientific skepticism

-- Active Users with Low Participation in Voting
-- Users active in the last three months with reputation over 500 with fewer than 10 votes per day since joining the site.
select top 1000
  id as [User Link],
  Reputation as Rep, 
  UpVotes + DownVotes as "Votes",
  UpVotes as "Up",
  DownVotes as "Down",
  datediff(day,CreationDate,(SELECT MAX(LastActivityDate) FROM Posts)) as "Days",
  (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
order by (UpVotes + DownVotes) / datediff(day,CreationDate,(SELECT MAX(LastActivityDate) FROM Posts)) desc

fork query

created apr 1 11 mattdm