Extreme Suggested Edit Rejectors

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

/* This returns top 200 users who have reviewed atleast 250 suggested edits
and have rejected the highest percentage of edits*/

select top 200 UserId as [User Link],
       approved,
       rejected,
       total,
       round(cast(rejected*100 as float)/total ,1) RejectedPercentage
 from (
       select UserId,
              count(case when VoteTypeId = 2 then 1 end) approved,
              count(case when VoteTypeId = 3 then 1 end) rejected,
              count(VoteTypeId) total
         from SuggestedEditVotes
        group by UserId
       ) as grouped
 where total >= 250
 order by RejectedPercentage desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results