Lowest Views/score ratio - Top Score/views ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Query looks at qustions with good views/score ratio

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Lowest Views/score ratio - Top Score/views ratio
-- Query looks at qustions with good views/score ratio
select top 200 Id as [Post Link], ViewCount, Score, CAST(CAST(ViewCount AS float)/Score AS DECIMAL(10,2)) [Voted by one in] from Posts 
where ViewCount > 0 AND Score > 2 AND PostTypeId = 1
order by CAST(ViewCount AS float)/Score

Enter Parameters

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