Answers to subsequently closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia

Q&A for academics and those enrolled in higher education

WITH InterestingAnswers AS (
  SELECT a.Id AS AnswerId, a.ParentId AS QuestionId
  FROM Posts AS a
  WHERE PostTypeId = 2 -- Answers only
    AND a.OwnerUserId = ##userId:int##
    AND (SELECT q.ClosedDate FROM Posts AS q WHERE q.Id = a.ParentId) > a.CreationDate
)

SELECT Count(QuestionId) FROM InterestingAnswers;

Enter Parameters

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