Q&A for professional and enthusiast programmers
SELECT t.TagName, COUNT(a.Id) AS NumAnswers, SUM(a.Score) AS TotalScore, AVG(a.Score + 0.0) AS AvgScore FROM Posts a JOIN Posts q ON a.ParentId = q.Id JOIN PostTags pt ON pt.PostId = q.Id JOIN Tags t ON t.Id = pt.TagId WHERE a.PostTypeId = 2 GROUP BY t.tagName, t.Id HAVING COUNT(q.Id) >= 100 ORDER BY AvgScore DESC