dplyr Questions ansswered in less than 1 day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT top 200 
  question.id as [Post Link],
  question.ownerUserID as [User Link],
  answer.ownerUserID as [User Link],
  TagName,
  cast(round(datediff(second, question.CreationDate, answer.CreationDate) / 60.0, 2) as numeric (36,2)) as Delay,
  len(answer.body) - (patindex('%</code></pre>%', answer.body) - patindex('%<pre><code>%', answer.body)) as [Length w/o code]
FROM posts as question
  INNER JOIN posts as answer
    ON question.acceptedAnswerID = answer.id
    AND question.ownerUserID != answer.ownerUserID
  INNER JOIN PostTags pt on pt.PostId = question.Id
  INNER JOIN Tags t on t.Id=pt.TagId
WHERE
  datediff(second, question.CreationDate, answer.CreationDate) BETWEEN 0 and 600
  AND TagName in ('r')
ORDER BY question.CreationDate DESC

Enter Parameters

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