What questions have the highest ratio of votes to views?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the top 50 questions, ordered by their score divided by the number of views they've received.

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

SELECT TOP 50 
Id as [Post Link],
(Score*1.0/ViewCount) as ScoreRatio,
Score,
ViewCount 
FROM Posts 
WHERE ViewCount > '##MinViewCount##' 
and Score > '##MinScore##' 
and ParentId is null
and CreationDate > DATEADD(day,DATEDIFF(day,##LastNDays##,GETDATE()),0)
ORDER BY ScoreRatio DESC

Enter Parameters

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