Negative vs. Positive Questions over time


Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

Select createYear, numNeg * 100.00 / NumQs as PercentNegative


    sum(case when score >= 0 then 1 else 0 end) as NumPos,
    sum(case when score >= 0 then 0 else 1 end) as NumNeg,
    year(CreationDate) as CreateYear,
    Count(*) as NumQs
  from Posts where posttypeid = 1
  group by
) as T
order by CreateYear

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results