Answers to subsequently closed questions


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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 to meta site
loading Hold tight while we fetch your results