Average question size (with word count)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 20 t.TagName, CEILING(AVG(LEN(p.Body)) / 5.1) AS average_word_length
FROM Posts p INNER JOIN PostTags pg
ON pg.PostId = p.Id
INNER JOIN Tags t ON pg.TagId = t.id
WHERE p.PostTypeId = 1 --Is a question
GROUP BY t.TagName, t.Count
ORDER BY t.Count DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results