Q&A for professional and enthusiast programmers
select answer_count, score_range, COUNT(*) N from ( select CreationDate, isnull(AnswerCount,0) answer_count, case when isnull(Score, 0) < 0 then 'negative' when isnull(Score, 0) = 0 then 'zero' when isnull(Score, 0) > 0 then 'positive' end score_range from PostsWithDeleted where PostTypeId = 1 -- Questions ) questions_with_score_range where ( answer_count <= 15 and CreationDate >= '2015-01-01' ) group by answer_count, score_range order by answer_count