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  *
  FROM  Users u
  WHERE Id IN (
              SELECT  p.OwnerUserId
                FROM  Posts p
                WHERE p.OwnerUserId IN (
                            SELECT  id
                              FROM  Users u
                              WHERE Reputation > 20000
                            )
                GROUP BY p.OwnerUserId
                HAVING (COUNT(*) = 1)
              )

Enter Parameters

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