Q&A for experienced flyers, pilots, and builders of drones and model aircraft
DECLARE @MinAnswers int = ##MinAnswers## SELECT TOP 30 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) and q.Tags like '%python%' --no self answers GROUP BY u.Id HAVING count(*) >= @MinAnswers ORDER BY AcceptedPercent DESC, NumAnswers DESC