2

Please login or register to vote for this query.

(click on this box to dismiss)

This query counts questions, answers and users with answers where the creation date of the answer precedes the creation date of the question. Most probably these are results of question merges and stuff, but they were they were surprising for me nevertheless.

Q&A for professional and enthusiast programmers

-- How many 'Clairvoyants'
-- This query counts questions, answers and users with answers where the creation date
-- of the answer precedes the creation date of the question.  
-- Most probably these are results of question merges and stuff, but they were
-- they were surprising for me nevertheless.


select
   Count(Distinct parent_post.id) as [Questions],
   Count(Distinct posts.owneruserid) as [Users],
   Count(Distinct posts.id) as [Answers]
from posts, posts as parent_post
where posts.posttypeid = 2 and
      posts.parentid = parent_post.id
and   datediff(SECOND, parent_post.creationdate, posts.creationdate) < 0

fork query

created jun 14 10 Mark Hurd