Tag Wikis and Their (lack of) Length

0

Please login or register to vote for this query.

(click on this box to dismiss)

Query 1 returns each tag wiki grouped by their length and the frequency of each length Query 2 returns the name of each tag wiki ordered by their length Query 3 returns each tag wiki excerpt grouped by its length and the frequency of each length

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT len(body) as [Length of Wiki], COUNT(len(body)) AS [Frequency]
FROM Posts
WHERE PostTypeId = 5
GROUP BY len(body)
ORDER BY COUNT(len(body)) DESC;

SELECT len(Posts.body), Tags.TagName 
FROM Tags 
INNER JOIN Posts 
ON Posts.Id = Tags.WikiPostId 
--WHERE len(body) = 0
ORDER BY len(Posts.body)

SELECT len(body) as [Length of Excerpt], COUNT(len(body)) AS [Frequency]
FROM Posts
WHERE PostTypeId = 4
GROUP BY len(body)
ORDER BY len(body)

Enter Parameters

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