Q&A for people looking to bypass life's everyday problems with simple tricks
select avg(ViewCount) views, count(*) N, '##tag##' from Posts where PostTypeId = 1 and Tags like '%##tag##%'