Q&A for science fiction and fantasy enthusiasts
-- Displays the highest-ranked questions, based on votes per view.
-- Views: Only view posts above a minimum amount of views of:
SELECT TOP 500 p.ID as [Post Link], p.OwnerUserId as [User Link], p.Tags as [Tags], ViewCount, Score, Round((Score*100.00)/ViewCount, 10) Percentage
FROM Posts p JOIN PostTypes pt on p.PostTypeID = pt.ID
WHERE pt.Name = 'Question' and ViewCount > ##Views:int##
ORDER BY Percentage DESC