Sportsmanship-eligible questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology

Q&A for biology researchers, academics, and students

SELECT
q.Id as [Post Link], COUNT(*) as [Other Answers]
FROM
  Posts q
INNER JOIN Posts a ON
  a.ParentId = q.Id AND
  a.OwnerUserId = ##UserId:int## AND
  a.Score > 0
INNER JOIN Posts oa ON
  oa.ParentId = q.Id
  AND oa.OwnerUserId != ##UserId:int##
-- WHERE  a.CreationDate > oa.CreationDate
GROUP BY
  q.Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results