0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for information security professionals

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(*) >= 700
ORDER BY
  COUNT(*) DESC;

fork query

edited mar 6 12

created mar 6 12 anonymous