Average Number of Views per Tag


Please login or register to vote for this query.

(click on this box to dismiss)

Shows which tags bring in the most viewers

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results