2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Total number of answers accepted 
-- Returns people with 0 accepted answers as blanks

SELECT
u.Displayname AS Name, 
COUNT(*) AS TotalAns,
AccAns,
ROUND(((AccAns+0.0) / COUNT(*)+0.0),2) AS PercAcc,
u.Reputation AS Rep,
a.OwnerUserId
FROM Posts AS a 
  JOIN Users AS u ON a.OwnerUserId = u.Id
  LEFT JOIN 
      (
       SELECT COUNT(*) AS AccAns, t.OwnerUserId
       FROM Posts AS t
       WHERE t.Id IN (SELECT AcceptedAnswerId FROM Posts)
       GROUP BY t.OwnerUserId
      ) AS t2 ON t2.OwnerUserId=a.OwnerUserId
WHERE PostTypeID = 2
GROUP BY a.OwnerUserID, u.Displayname, u.Reputation, AccAns
ORDER BY Rep DESC

fork query

edited sep 27 13

created sep 26 13 Andy W