Average Number of Views for the top 20 tags


Please login or register to vote for this query.

(click on this box to dismiss)

This will show the top 20 tags for a given site, and show the average number of views for the tag.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select TOP 20
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 [Question Count] Desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results