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