instruction: Tags ordered by average answer score (including CW).
response: SELECT RANK() OVER (ORDER BY AVG(CAST(a.Score AS FLOAT)) DESC) AS Rank, t.TagName, AVG(CAST(a.Score AS FLOAT)) AS "average_score", COUNT(a.Id) AS Count, SUM(a.Score) AS "total_score" FROM Posts AS q INNER JOIN Posts AS a ON q.Id = a.ParentId INNER JOIN PostTags AS pt ON q.Id = pt.PostId INNER JOIN Tags AS t ON t.Id = pt.TagId GROUP BY t.TagName HAVING (COUNT(a.Id) >= '##min?10##') ORDER BY AVG(CAST(a.Score AS FLOAT)) DESC LIMIT 100