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

WITH 
AllQuartiles(RoundedLength,PostScore,Quartile)
AS (
  SELECT TOP(1000) 
  ROUND(LEN(Body), -3) AS RoundedLength,
  Score AS PostScore,
  NTILE(4) OVER(PARTITION BY ROUND(LEN(Body), -3) ORDER BY Score) AS Quartile
  FROM Posts
  WHERE 
    PostTypeId = 2 AND
    LEN(Body) <= 500
  ORDER BY
    ROUND(LEN(Body), -3),Score
)
SELECT RoundedLength,PostScore,Quartile From AllQuartiles

view current version

edited jul 24 14 E.P.

created jul 24 14 Chris White