Average Score 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

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

declare @TagString nvarchar(25) = ##tagName:string##

select t.tagName,(sum(p.ViewCount)/count(*)) as [Average Views] 
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 to meta site
loading Hold tight while we fetch your results