# of posts with a positive vs negative score

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 
  (SELECT COUNT(id) FROM Posts WHERE Score >= 0) AS 'Posts with postive Score', 
  (SELECT COUNT(id) FROM Posts WHERE Score < 0) As 'Posts with negative Score',
  (SELECT COUNT(id) FROM Posts WHERE Score >= 0)/(SELECT COUNT(id) FROM Posts WHERE Score < 0) As 'Ratio'

Enter Parameters

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