Negative vs. Positive Questions over time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for expert programmers interested in professional discussions on software development

Select
  case
    when score >= 0 then 1
    else -1
  end,
  year(CreationDate),
  Count(1)
from Posts where posttypeid = 2
group by
  case
    when score >= 0 then 1
    else -1
  end,
  year(CreationDate)
order by 2

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results