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.0* (SELECT COUNT(Id) FROM Questions WHERE AnswerCount = 0 AND ClosedDate IS NULL)
 /(SELECT Count(Id) FROM Questions)

Enter Parameters

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