Answered posted after question closure

0

Please login or register to vote for this query.

(click on this box to dismiss)

Top 20 most late answers that were posted after the question was already closed.

Project Management

Q&A for project managers

WITH tmp AS (
  SELECT TOP 20
    q.ClosedDate AS QuestionClosureDate,
    a.CreationDate AS AnswerDate,
    DATEDIFF(MINUTE, q.ClosedDate, a.CreationDate) AS Late,
    a.Id AS AnswerId,
    a.ParentId AS QuestionId
  FROM Posts AS a
  LEFT JOIN Posts AS q ON a.ParentId = q.Id
  WHERE
    q.ClosedDate IS NOT NULL AND
    a.CreationDate > q.ClosedDate AND
    NOT EXISTS (
      SELECT *
      FROM PostHistory AS ph
      WHERE
        ph.PostId = a.Id AND
        ph.PostHistoryTypeId = 38
    )
  ORDER BY
    late DESC
)
SELECT
  QuestionClosureDate,
  AnswerDate,
  CONCAT(Late/60, ' h ', Late%60, ' min') AS Late,
  AnswerId,
  CONCAT('https://stackoverflow.com/a/', AnswerId) AS AnswerLink,
  QuestionId
FROM tmp;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results