Probability of a closed question to get reopened

1

Please login or register to vote for this query.

(click on this box to dismiss)

NowClosed: the questions closed now. ClosedOnce: questions closed at least once. This query does not see the now deleted questions.

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT COUNT(ClosedDate) AS NowClosed, COUNT(*) AS ClosedOnce
FROM Posts
WHERE Id IN (
  SELECT DISTINCT PostId
  FROM PostHistory
  WHERE PostHistoryTypeId = 10
)

Enter Parameters

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