Users with only one question and a self-answer scoring > 0

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

SELECT TOP 10 u.Id AS [User Link]
  FROM Users AS u
  INNER JOIN Posts AS q
    ON q.OwnerUserId = u.Id
  INNER JOIN Posts AS a
    ON q.Id = a.ParentId AND a.OwnerUserId = u.Id
   AND a.Score > 0
  LEFT OUTER JOIN Posts AS p
    ON p.OwnerUserId = u.Id AND p.Id NOT IN (a.Id, q.Id)
  WHERE p.Id IS NULL

Enter Parameters

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