0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
(CAST(Count(n.Id) AS float) / (SELECT Count(*) FROM Posts o) * 100) AS AnsweredPercentage 
FROM
  Posts n
    INNER JOIN
  Posts o ON n.Id = o.AcceptedAnswerId

fork query

created feb 21 21 tombjarne