Q&A for computer enthusiasts and power users
-- Amount of Posts per Post Length SELECT FLOOR(LEN(Body)/500) * 500 AS [Post Length], COUNT(Id) AS [Amount of Posts] FROM Posts WHERE PostTypeId = 2 GROUP BY FLOOR(LEN(Body)/500) * 500 ORDER BY [Amount of Posts] DESC