SELECT 100*AVG(CASE WHEN AcceptedAnswerId IS NOT NULL THE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematica

Q&A for users of Mathematica

SELECT 100*AVG(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1.0 ELSE 0 END)
FROM Posts
WHERE PostTypeId = 1
AND Score >= 0
AND AnswerCount > 0
AND ClosedDate IS NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results