Questions below a threshold but still open

0

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 
  p.Score, COUNT(p.Score) AS "Open Questions" 
FROM 
  Posts AS p
WHERE 
  Score <= ##MaxScore?-4## 
  AND Score >= ##MinScore?-10## 
  AND ClosedDate Is NULL 
  AND AnswerCount > 0
GROUP BY Score
ORDER BY Score DESC

Enter Parameters

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