3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

select '##tag##' tag, count(*) N, avg(ViewCount) avg_views 
       
from Posts p
     join PostTags on p.Id = PostId
     join Tags t on t.Id = TagId
where PostTypeId = 1
      and TagName in ('##tag##')

view current version

edited sep 17 14

created sep 17 14 Jon "not doe" Ericson