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 about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
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 * from Counts;