Fastest-closed questions with 5 close votes

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 TOP 100 p.Id as [Post Link],
               p.CreationDate as [Create Date],
               p.ClosedDate as [Close Date]
FROM Posts p
WHERE p.PostTypeId = 1
AND p.Id in (SELECT PostId FROM Votes WHERE VoteTypeId = 6
             GROUP BY PostId
             HAVING COUNT(PostId) = 5)
AND DATEDIFF(DAY, p.CreationDate, p.ClosedDate) < 1
ORDER BY p.ClosedDate - p.CreationDate ASC

Enter Parameters

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