Custom - Questions between time and response times

0

Please login or register to vote for this query.

(click on this box to dismiss)

Views, Score and Answers per Game (with limited blacklist for other tags)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

SELECT question.title, question.id, question.creationDate, Tagname, DATEDIFF(MINUTE, question.CreationDate, answer.CreationDate) diff
FROM Posts question
  INNER JOIN Posts answer ON question.Id = answer.ParentId
  JOIN PostTags ON question.Id = PostTags.PostId
  JOIN Tags ON PostTags.TagId = Tags.Id
  WHERE question.PostTypeId = 1 
        AND question.CreationDate >= '2019-10-07'
        AND answer.CreationDate <='2019-12-31'
        AND question.AcceptedAnswerId = answer.Id
        AND Tagname like '%snowflake%'
        AND answer.Score > 0
ORDER BY question.Id ASC

Enter Parameters

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