select cast(sum(answercount) as float) / (count(*))[Answe...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Astronomy

Q&A for astronomers and astrophysicists

select cast(sum(answercount) as float) 
/ (count(*))[Answer Ratio]
from
posts
where posttypeid = 1 -- Q
and answercount >= 1
or closeddate is not null

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results