Users with more then 3000 accepted answers.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

SELECT
  u.Id AS [User Link],
  COUNT(*) AS 'Accepted Answers'
FROM
  Users AS u
  LEFT JOIN Posts AS p1 ON p1.OwnerUserId=u.Id
  LEFT JOIN Posts AS p2 ON p2.AcceptedAnswerId=p1.Id
WHERE
  p2.Id IS NOT NULL
GROUP BY
  u.Id
HAVING
  COUNT(*) >= 3000
ORDER BY
  COUNT(*) DESC;

Enter Parameters

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