Shows which tags bring in the most viewers
Q&A for community managers, administrators, and moderators
select t.tagName,(sum(p.ViewCount)/count(*)) as [Average Views], Count(*) AS [Question Count] from Posts p inner join PostTags pt on p.Id = pt.PostId inner join Tags t on pt.TagId = t.Id Group By t.tagName Order by [Average Views] Desc