0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with the lowest score to views ratio (must have 200 views or +1)

Q&A for those using, extending or developing Emacs

-- Least liked questions
-- Questions with the lowest score to views ratio (must have 200 views or +1)

SELECT TOP 100
  Id AS [Post Link],
  Score,
  ViewCount,
  CAST(Score AS FLOAT)/ViewCount AS Ratio
FROM
Posts
WHERE
  PostTypeId = 1
  AND (Score > 0 OR ViewCount >= 500 OR (ViewCount >= 200 AND AnswerCount >= 2))
ORDER BY
  Ratio ASC

fork query

created feb 22 11 Renesis