0

Please login or register to vote for this query.

(click on this box to dismiss)

Plots quartiles of the answer score distribution as a function of answer length.

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 
LEN(Body) AS Length,
Score AS Score,
NTILE(4) OVER(PARTITION BY ROUND(LEN(Body), -3) ORDER BY Score)
FROM Posts
WHERE PostTypeId = 2 AND
      LEN(Body) <= 500
ORDER BY
  LEN(Body),Score

view current version

edited jul 24 14 E.P.

created jul 24 14 Chris White