0

Please login or register to vote for this query.

(click on this box to dismiss)

Users active in the last two months with reputation over 500 and less than one vote per day since joining the site.

Q&A for SharePoint enthusiasts

-- Active Users with Low Participation in Voting
-- Users active in the last two months with reputation over 500 and less than one vote per day since joining the site.

select
  id as [User Link],
  Reputation as Rep,
  UpVotes + DownVotes as "Votes",
  UpVotes as "Up",
  DownVotes as "Down",
  round((UpVotes + DownVotes + 0.0) / datediff(day,CreationDate,(SELECT MAX(LastActivityDate) FROM Posts)),3) as "Per Day"
from Users
where Reputation > 500
  and datediff(month,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 2
  and (UpVotes + DownVotes) / datediff(day,CreationDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 1
order by "Per Day" asc

fork query

created apr 1 11 mattdm