Returns average number of tags per question on a site. Additionally it also returns tag count breakdown with question counts. Best viewed as "Text-only results"
Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
with Counts as ( select len(Tags) - len(replace(Tags, '<', '')) as Tags, count(*) as QuestionCount from Posts where PostTypeId = 1 group by len(Tags) - len(replace(Tags, '<', '')) ) select sum(QuestionCount), cast(sum(Tags * QuestionCount) as decimal) / sum(QuestionCount) from Counts union all select * from Counts