Top score/views ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Queries to look at interesting questions

Emacs

Q&A for those using, extending or developing Emacs

-- Top score/views ratio
-- Queries to look at interesting questions
select top 10 Id as [Post Link], ViewCount, Score, CAST(Score AS float)/ViewCount from Posts 
where ViewCount > 0 AND Score > 10
union all
select top 10 Id as [Post Link], ViewCount, Score, CAST(Score AS float)/ViewCount from Posts
where ViewCount > 0 AND Score between 0 and 9

Enter Parameters

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