0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

-- Total number of answers accepted 

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

fork query

edited sep 27 13 anonymous

created sep 26 13 Andy W