0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

created mar 10 19 Vogel612