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