Average Number of Views for the top 20 tags

1

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

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached