0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT
  COUNT(*)
FROM
  Posts Question
INNER JOIN Posts Answer ON (Answer.ParentId = Question.Id)
WHERE
  Question.PostTypeId = 1
  AND Answer.PostTypeId = 2
  AND Question.OwnerUserId = Answer.OwnerUserId
  /* Limit posts whilst testing */
  AND Question.Id < 1000

view current version

edited aug 18 12

created aug 18 12 halfer