Number of unclosed questions with close votes per month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT
  CAST(MIN(P.CreationDate) as date) as PostDay,
  COUNT(DISTINCT P.Id)
FROM Posts P
INNER JOIN PendingFlags PF ON P.Id = PF.PostId
WHERE PF.FlagTypeId = 14
GROUP BY YEAR(P.CreationDate), MONTH(P.CreationDate)
ORDER BY PostDay

Enter Parameters

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