0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for 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

fork query

edited nov 21 17 anonymous

created nov 21 17 Jon "not doe" Ericson