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 cast(Tags as varchar) as [Number of tags on question], cast(QuestionCount as varchar) as [Number of questions] from Counts union all select cast((cast(sum(Tags * QuestionCount) as money) / sum(QuestionCount)) as varchar), sum(QuestionCount) from Counts