0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT AVG(CAST(tmp.HasAcceptedAnswer AS FlOAT))
FROM (
SELECT TOP 100000 Id, 
(CASE WHEN AcceptedAnswerId > 0 THEN 1
ELSE 0 END) AS HasAcceptedAnswer
FROM Posts
) AS tmp

view current version

edited dec 3

created dec 3 jon.doe46451