Does not count self-answers. Shows users with at least @MinAnswers answers.
Q&A about the site for those interested in the geology, meteorology, oceanography, and environmental sciences
-- Users with highest accept rate of their answers -- Does not count self-answers. -- Shows users with at least @MinAnswers answers. DECLARE @MinAnswers int = ##MinAnswers## SELECT TOP 100 u.Id AS [User Link], count(*) AS NumAnswers, sum(case when q.AcceptedAnswerId = a.Id then 1 else 0 end) AS NumAccepted, (sum(case when q.AcceptedAnswerId = a.Id then 1 else 0 end)*100.0/count(*)) AS AcceptedPercent FROM Posts a INNER JOIN Users u ON u.Id = a.OwnerUserId INNER JOIN Posts q ON a.ParentId = q.Id WHERE (q.OwnerUserId <> u.Id OR q.OwnerUserId IS NULL) --no self answers GROUP BY u.Id HAVING count(*) >= @MinAnswers ORDER BY AcceptedPercent DESC, NumAnswers DESC