WITH Questions AS ( SELECT Id, AnswerCount, ClosedDate FR...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

WITH Questions AS (
  SELECT
    Id,
    AnswerCount,
    ClosedDate
  FROM Posts
  WHERE PostTypeId = 1
)
SELECT
100* (SELECT COUNT(Id) FROM Questions WHERE AnswerCount = 0 AND ClosedDate IS NULL)
 /(SELECT Count(Id) FROM Questions)

Enter Parameters

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