Worst Acceptors

1

Please login or register to vote for this query.

(click on this box to dismiss)

List of users ranked by worst rate of accepting an answer on their own questions with answers.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
  u.Id AS [UserId],
  CONCAT('site://u/', u.Id, '|', u.DisplayName) AS [User Display Name],
  COUNT(p.Id) AS [Answered Question Count],
  COUNT(CASE WHEN p.AcceptedAnswerId IS NOT NULL THEN 1 ELSE NULL END) AS [Accepted Answers],
  COUNT(P.AcceptedAnswerId) / (COUNT(*) * 1.) AS [%Accept Rate]
FROM Posts p
JOIN Users u ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 1 -- Question
  AND p.AnswerCount > 0 -- Questions with > 0 answer
GROUP BY p.OwnerUserId, u.DisplayName, u.Id
HAVING COUNT(p.Id) >= ##QCount:int?10##
ORDER BY COUNT(P.AcceptedAnswerId) / (COUNT(*) * 1.), COUNT(p.Id) DESC

-- QCount: Minumum Answered Questions:

Enter Parameters

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