Number of 'identify-this-game' questions given accepted answers more than a month after being asked

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 COUNT(*) FROM Posts Questions
INNER JOIN Votes ON Votes.PostID = Questions.AcceptedAnswerId
WHERE VoteTypeId = 1
    AND DateDiff(hour, Questions.CreationDate, Votes.CreationDate) > 24*28
    AND Questions.Tags LIKE '%identify-this-game%'

Enter Parameters

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