Highly viewed but lowly voted questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Popular questions (those viewed at least 1000 times) having a positive score by score-to-views ratio.

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- Highly viewed but lowly voted questions
-- Popular questions (those viewed at least 1000 times) having a positive score by score-to-views ratio.
select top 1000
    Id as [Post Link],
    Score, ViewCount,
    cast(Score as numeric) / cast(ViewCount as numeric) as Ratio
from posts where ViewCount >= 1000 and Score > 0
order by Ratio

Enter Parameters

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