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)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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-01-01'
        AND answer.CreationDate <='2019-10-07'
        AND Tagname like '%snowflake-datawarehouse%'
        AND answer.Score > 0
ORDER BY question.Id ASC

Enter Parameters

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