Top 20 Questions with high Score-To-ViewCount Ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT Top 20 Questions.Id AS [Post Link], 
       Questions.ViewCount, 
       Questions.Score as Score,
       ROUND(1.0 * Questions.Score/Questions.ViewCount, 8) AS scTovc

FROM Posts AS Answers 
    INNER JOIN Posts AS Questions 
    ON Questions.Id = Answers.ParentId
    /* WHERE Questions.ViewCount > 5000000 */

GROUP BY
Questions.Id, 
Questions.ViewCount,
Questions.Score

ORDER BY scTovc DESC

Enter Parameters

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