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.
Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language
-- 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