Includes questions that have at least 5 million views.
Q&A about the site for professional linguists and others with an interest in linguistic research and theory
id [Post Link],
(select round(sum(score)/sum(1),1) AvgScore from posts pp where pp.parentid=p.id and pp.closeddate is null) AvgAnswerScore,
from posts p
order by viewcount desc