"Good" trivial questions - part 2

0

Please login or register to vote for this query.

(click on this box to dismiss)

Users with more than 100 questions that have been upvoted and have 500 or less rep

Stack Overflow

Q&A for professional and enthusiast programmers

-- "Good" trivial questions
-- Users with more than 100 questions that have been upvoted

SELECT DisplayName, TotalQuestions FROM
   (SELECT OwnerUserId, COUNT(*) AS TotalQuestions
   FROM
      (SELECT * FROM Posts
       WHERE
          Score > 0 AND
          Score < 5 AND
          PostTypeId = 1
       ) posts
   GROUP BY OwnerUserId
   HAVING
      COUNT(*) > 100) AS UpvotedQuestions
INNER JOIN Users ON
   Users.Id = UpvotedQuestions.OwnerUserId AND
   Users.Reputation <= 500
ORDER BY TotalQuestions DESC

Enter Parameters

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