instruction: Answer score by post length. Groups posts of varying length together by answer score for a given user.
response: SELECT p.Score AS AnswerScore, SUM(CASE WHEN LENGTH(p.Body) <= 200 THEN 1 ELSE 0 END) AS PostsWithLen_0_200, SUM(CASE WHEN LENGTH(p.Body) BETWEEN 201 AND 500 THEN 1 ELSE 0 END) AS PostsWithLen_201_500, SUM(CASE WHEN LENGTH(p.Body) BETWEEN 501 AND 1000 THEN 1 ELSE 0 END) AS PostsWithLen_501_1000, SUM(CASE WHEN LENGTH(p.Body) BETWEEN 1001 AND 2000 THEN 1 ELSE 0 END) AS PostsWithLen_1001_2000, SUM(CASE WHEN LENGTH(p.Body) > 2001 THEN 1 ELSE 0 END) AS PostsWithLen_2001plus FROM Posts AS p WHERE p.OwnerUserId = @UserId AND p.PostTypeId = 2 GROUP BY p.Score