Answers to subsequently closed questions


Please login or register to vote for this query.

(click on this box to dismiss)


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

Switch sites:
loading Hold tight while we fetch your results