instruction: Answer score as a function of length, normalized by views. Plots average value of (answer score / number of views), +/- 1 standard deviation, as a function of binned answer length.
response: SELECT AVG(LENGTH(A.Body)) AS AverageLength, AVG(CAST(A.Score AS FLOAT) / Q.ViewCount) AS AnswerScorePerViews, AVG(CAST(A.Score AS FLOAT) / Q.ViewCount) + STDEV(CAST(A.Score AS FLOAT) / Q.ViewCount) AS PlusOneSigma, AVG(CAST(A.Score AS FLOAT) / Q.ViewCount) - STDEV(CAST(A.Score AS FLOAT) / Q.ViewCount) AS MinusOneSigma FROM Posts AS A INNER JOIN Posts AS Q ON A.ParentId = Q.Id WHERE A.PostTypeId = 2 AND LENGTH(A.Body) <= 20000 GROUP BY ROUND(LENGTH(A.Body), -3) ORDER BY ROUND(LENGTH(A.Body), -3)