Percent of answered questions for sabre


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT SUM(case when AnswerCount = 0 then 0.0 else 1.0 end) / COUNT(*)
  FROM Posts
  PostTypeId = 1 AND
  DeletionDate is null AND
  ClosedDate is null AND
  CreationDate >= '2016-05-01' AND
  CreationDate < '2017-05-01' AND
  Tags like '%sabre|%'

Enter Parameters

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