0

Please login or register to vote for this query.

(click on this box to dismiss)

Find users with the best accept rates, ordered by accept rate and total number of answers. Those with less than 5 answers are excluded.

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Best accept rate percentage
-- Find users with the best accept rates, ordered by accept rate and total number of answers. Those with less than 5 answers are excluded.

DECLARE @MinRate float = ##MinRate:float##

SELECT 
    t.OwnerUserId AS [User Link],
    t.Total,
    Round(t.Accepted * 100.0 / t.Total, 1) AS [Percent]
  FROM
    (SELECT
         a.OwnerUserId,
         Count(a.Id) AS [Total],
         Sum(CASE q.AcceptedAnswerId WHEN a.Id THEN 1 ELSE 0 END) AS [Accepted]
       FROM Posts AS a
         JOIN Posts AS q
           ON a.ParentId = q.Id
       WHERE q.postTypeId = 1 AND a.postTypeId = 2 AND a.OwnerUserId <> q.OwnerUserId
       GROUP BY a.OwnerUserId
   ) AS t 
WHERE t.[Total] >= 6 AND (CAST(t.[Accepted] AS FLOAT) / t.[Total]) >= @MinRate
ORDER BY (CAST(t.[Accepted] AS FLOAT) / t.[Total]) DESC, t.[Total] DESC

fork query

created aug 31 11 ww.galen