0

Please login or register to vote for this query.

(click on this box to dismiss)

The percentage of suggested edits that each user on the site accepts out of their total reviews. Users with less than 25 reviews don't qualify.

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT
  RepBand,
  AcceptRateBand,
  COUNT(*)
FROM (
SELECT
CEILING(LOG(Reputation)) RepBand,
  5*CEILING([Accept percentage]/5) AcceptRateBand
FROM (
SELECT
  UserId,
--  SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS [Accepts],
--  SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS [Rejects],
--  COUNT(*) AS [Total Reviews],
  (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS DECIMAL) / COUNT(*)) * 100 
    AS [Accept percentage]
FROM SuggestedEditVotes
WHERE UserId <> -1 -- Ignore the community user
GROUP BY UserId
HAVING COUNT(*) >= 2--5 -- Ignore users with less than 25 reviews
) RawAccept
INNER JOIN Users ON RawAccept.UserId=Users.Id
--ORDER BY (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS DECIMAL) / COUNT(*)) DESC
) RawCorrel
GROUP BY RepBand,AcceptRateBand

fork query

edited jul 17 12 AakashM

created jul 17 12 jadarnel27