Score per views (draft)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy

Q&A for those interested in the study of the fundamental nature of knowledge, reality, and existence

select top 1000 Q.Id as [Post Link], A.Id as AnswerId
  , A.Score, Q.ViewCount, cast(A.Score as decimal)/ Q.ViewCount as Ratio
from Posts Q
inner join Posts A on A.ParentId = Q.Id
inner join PostTags PT on PT.PostId = Q.Id
inner join Tags T on T.Id = PT.TagId
where T.TagName = 'haskell'
  and A.Score > 0
order by Ratio desc

Enter Parameters

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