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.

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

edited mar 2 12

created mar 2 12

pearsonartphoto

Enter Parameters

Options: Text-only results Include execution plan

Switch sites:

Hold tight while we fetch your results

Results Messages Graph Execution Plan

Download CSV Download XML

:records rows returned in :time ms:cached

Average Number of Views for the top 20 tags

Please login or register to vote for this query.

Enter Parameters

To avoid spam queries, all anonymous users must solve a captcha