Highest Scoring Questions by One Time User

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

SELECT  p.OwnerUserId
  FROM  Posts p
    INNER JOIN  (
                SELECT  OwnerUserId
                  FROM  Posts p
                  WHERE p.PostTypeId = 1
                  GROUP BY OwneruserId
                  HAVING COUNT(*) = 1
                ) a ON a.OwnerUserId = p.OwnerUserId
  WHERE p.Score > 200

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results