visual studio 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 COUNT(*)
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 86400
  AND TagName in ('visual-studio')
  AND YEAR(question.CreationDate) = 2014

Enter Parameters

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