instruction: Average view count for specific tag.
response: SELECT Tags.TagName, AVG(CAST(ViewCount AS INT)) AS AverageViewCount, COUNT(Posts.Id) AS QuestionCount FROM Tags JOIN PostTags ON Tags.Id = PostTags.TagId JOIN Posts ON PostTags.PostId = Posts.Id WHERE NOT AcceptedAnswerId IS NULL AND Tags.TagName = '##TagName##' GROUP BY Tags.TagName ORDER BY AverageViewCount DESC