Q&A for gardeners and landscapers
SELECT Top 10 TagName, Count(Posts.Id) AS Questions, CAST(AVG(CAST(Score AS float)) as numeric(6,2)) AS [Average Score] FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.Id = PostTags.PostId WHERE PostTypeId = 1 GROUP BY TagName HAVING Count(Posts.Id) >= 5 ORDER BY [Average Score] DESC