Has the most rep, but never accepted anything

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

WITH Raw AS (
  SELECT
    OwnerUserId AS UserId,
    COUNT(*) AS Questions
  FROM Posts
  WHERE
    PostTypeId = 1
    AND
    OwnerUserId > 0
  GROUP BY OwnerUserId
  HAVING COUNT(AcceptedAnswerId)=0
)
SELECT TOP 100
  Users.Id,
  Users.Id AS [User Link],
  Users.Reputation,
  Raw.Questions
FROM Raw, Users
WHERE Raw.UserId = Users.Id
ORDER BY Users.Reputation DESC, Users.Id

Enter Parameters

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