0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  Answers.Id AS [Post Link],
  Answers.CreationDate AS "Answered Date",
  Questions.CreationDate AS "Asked Date",
  DATEDIFF(day, Questions.CreationDate, Answers.CreationDate) AS "Date Delta Days",
  Answers.Score
FROM
  Posts AS Answers
INNER JOIN
  Posts AS Questions
ON
  Answers.PostTypeId = 2 AND
  Answers.OwnerUserId = '##UserId?895245##' AND
  Answers.CreationDate < '##Date?9999-01-01##' AND
  Questions.Id = Answers.ParentId AND
  DATEDIFF(day, Questions.CreationDate, Answers.CreationDate) > 60
ORDER BY
  Answers.Score ASC

fork query

edited jul 1 19

created jul 1 19 cirosantilli