Most effective Fastest Guns in the West (enlightened percentage times quantity)

4

Please login or register to vote for this query.

(click on this box to dismiss)

Top 500 most effective Fastest Guns in the West Enlightened badges weighted against total Accepted answers with score >= 10 Enlightened requires an Accepted Answer with score >= 10, posted first. The higher their number * higher percentage of all accepted answers makes for a very effective Fastest Gun in the West.

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

-- Top 500 most effective Fastest Guns in the West
-- Enlightened badges weighted against total Accepted answers with score >= 10
-- 
-- Enlightened requires an Accepted Answer with score >= 10, posted first
-- The higher their number * higher percentage of all accepted answers makes
-- for a very effective Fastest Gun in the West

WITH QualifyingAccepts (UserId, Accepted) AS (
    SELECT TOP 500
        a.OwnerUserId as UserId,
        COUNT(DISTINCT a.Id) AS Accepted
    FROM Votes v
    INNER JOIN Posts a on v.PostId = a.Id
    INNER JOIN Posts q 
            ON q.AcceptedAnswerId = a.Id AND q.OwnerUserId != a.OwnerUserId
    WHERE v.VoteTypeId = 1
      AND a.Score >= 10
    GROUP BY a.OwnerUserId
    ORDER BY Accepted DESC
)
SELECT
    qa.UserId as [User Link],
    Accepted as [Accepted >= 10],
    COUNT(b.Id) as Enlightened,
    ROUND(CAST(COUNT(b.Id) AS FLOAT) * 100 / Accepted, 2) AS [Percentage Enlightened],
      ROUND(COUNT(b.Id) * (CAST(COUNT(b.Id) AS FLOAT) / Accepted), 2)  AS [Weighting]
FROM QualifyingAccepts qa
INNER JOIN Badges b on b.UserId = qa.UserId
WHERE b.Name = 'Enlightened'
GROUP BY qa.UserId, Accepted
ORDER BY Weighting DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results