instruction: Averages for tags of post questions from [AskDifferent].
response: SELECT t.TagName, t.Count, x.* FROM Tags AS t INNER JOIN (SELECT TagId, ROUND(AVG(CAST(ViewCount AS FLOAT)), 2) AS AvgViewCount, ROUND(AVG(CAST(AnswerCount AS FLOAT)), 2) AS AvgAnswerCount, ROUND(AVG(CAST(CommentCount AS FLOAT)), 2) AS AvgCommentCount, ROUND(AVG(CAST(FavoriteCount AS FLOAT)), 2) AS AvgFavoriteCount, SUM(FavoriteCount) AS SumFavoriteCount FROM PostTags AS pt LEFT JOIN Posts AS p ON pt.PostId = p.Id WHERE PostTypeId = 1 GROUP BY TagId) AS x ON x.TagId = t.Id ORDER BY SumFavoriteCount DESC